Time Mysql Formatting

The Time format come formatted like hh:mm:ss.mmmmmm ( unsure if the last part is ms. Just like in the following query result:

{
    id: 2,
    employeeId: 1,
    day: 1,
    startTime: '09:02:00.000000',
    endTime: '22:00:00.000000'
  }

{
    id: 2,
    employeeId: 1,
    day: 1,
    startTime: '09:02:00.000000',
    endTime: '22:00:00.000000'
  }

In the Drizzle Studio, it shows as hh:mm - which is what I want - If that's not something I did wrong, what should I use to get it in that format?

1 Reply

GTOP•2mo ago

. . .