working with datetime in drizzle
Problem:- I don’t know what date time is working in drizzle
Drizzle schema export const reminders = mysqlTable( "reminders", { id: int("id").notNull().autoincrement().primaryKey(), created_at: timestamp("created_at").defaultNow(), due_date: datetime("due_time").notNull(), should_send_mail: boolean("should_send_mail"), mail_sended: boolean("mail_sended").default(false), user_id: varchar("user_id", { length: 255, }).notNull(), question_no: int("question_no").notNull(), }, (reminder) => ({ ReminderCreatorIdIndex: index("reminder_creator_id_index").on( reminder.user_id ), }) ); I am giving drizzle reminderData: { dueDate: 2023-07-11T18:30:00.000Z, shouldSendMail: true } this value and drizzle is storing these value {"id":21,"created_at":"2023-07-11T17:21:35.000Z","due_date":"2023-07-11T13:00:00.000Z","should_send_mail":true,"mail_sended":false,"user_id":"dfc468c8-d3c7-4385-904b-6c40aa699104","question_no":2 Why there is difference can anyone tell me what is problem
Drizzle schema export const reminders = mysqlTable( "reminders", { id: int("id").notNull().autoincrement().primaryKey(), created_at: timestamp("created_at").defaultNow(), due_date: datetime("due_time").notNull(), should_send_mail: boolean("should_send_mail"), mail_sended: boolean("mail_sended").default(false), user_id: varchar("user_id", { length: 255, }).notNull(), question_no: int("question_no").notNull(), }, (reminder) => ({ ReminderCreatorIdIndex: index("reminder_creator_id_index").on( reminder.user_id ), }) ); I am giving drizzle reminderData: { dueDate: 2023-07-11T18:30:00.000Z, shouldSendMail: true } this value and drizzle is storing these value {"id":21,"created_at":"2023-07-11T17:21:35.000Z","due_date":"2023-07-11T13:00:00.000Z","should_send_mail":true,"mail_sended":false,"user_id":"dfc468c8-d3c7-4385-904b-6c40aa699104","question_no":2 Why there is difference can anyone tell me what is problem
0 Replies