HDBC converting a date sql value to UTCTime

[George Moschovitis]

Hello,

I am HDBC with the Postgres driver. I am trying to read a simple date
column from the DB:

stmt <- DB.prepare conn "SELECT date FROM my_table ORDER BY date DESC
LIMIT 1"
DB.execute stmt []
DB.commit conn
rows <- fetchAllRows' stmt
let ((d:_):_) = rows

the d variable is of type:

SqlEpochTime 1213736400

I am wondering how to convert this value to an UTCTime value.

Any help appreciated (I am a newbie).

-g.

[Matthew Danish]

After you pattern match SqlEpochTime and pull out the integer, what
you have here appears to be POSIX time. The time library has a module
for dealing with that: Data.Time.Clock.POSIX

The documentation is available here, among the standard library API
docs:

http://haskell.org/ghc/docs/latest/html/libraries/time/Data-Time-Clock-POSIX.html