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
