Hello please help, I want to query records from Postgres database using order by

creation_date,

the creation_date is

UTC

please how can I query the result using the

PST

time zone USING KTOM in KTOR This is my query:

val customers = db

._from_(Customers)

._select_()

._limit_(offset = offset, limit = limit)

._orderBy_(Customers.creationDate._desc_())

._map_ *{* row *->* Customers.createEntity(row) *}*

Sorting by date is independent of timezone.

So please how can I transform the column date to date in pdt

Don’t know the DateTime APi by hard but something along

DateTimeFormatter.ISO_DATE_TIME.parse( column).toDate(ZoneId.of(“PST”))

Thank you. But this cannot work KTORM query api

I do not get the correlation with ktorm.

ok, I mean select using

at timezone