Hello please help, I want to query records from Postgres database using order by `creation_date,` th...

# getting-started

[Aminu Babayo Shehu]

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) *}*

[Benoît Liessens]

Sorting by date is independent of timezone.

[Aminu Babayo Shehu]

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

[Benoît Liessens]

Don’t know the DateTime APi by hard but something along
DateTimeFormatter.ISO_DATE_TIME.parse( column).toDate(ZoneId.of(“PST”))

[Aminu Babayo Shehu]

Thank you. But this cannot work KTORM query api

[Benoît Liessens]

I do not get the correlation with ktorm.

[Aminu Babayo Shehu]

ok, I mean select using at timezone