[Haskell-cafe] 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.



-- 
http://gmosx.me.gr
http://joy.gr
http://cull.gr
http://nitroproject.org
http://phidz.com
http://joyerz.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.haskell.org/pipermail/haskell-cafe/attachments/20080619/80f35aa6/attachment.htm