Alternatively is there a way to create a UTCTime value from an epoch integer (no of seconds since epoch).<br>I can't find a suitable constructor with Hoogle.<br><br>thank you in advance,<br>George.<br><br><br><div class="gmail_quote">
On Thu, Jun 19, 2008 at 10:08 PM, George Moschovitis <<a href="mailto:george.moschovitis@gmail.com">george.moschovitis@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br><br>I am HDBC with the Postgres driver. I am trying to read a simple date column from the DB:<br><br>stmt <- DB.prepare conn "SELECT date FROM my_table ORDER BY date DESC LIMIT 1"<br>DB.execute stmt []<br>
DB.commit conn<br>rows <- fetchAllRows' stmt<br>let ((d:_):_) = rows<br><br>the d variable is of type:<br><br>SqlEpochTime 1213736400<br><br>I am wondering how to convert this value to an UTCTime value. <br><br>Any help appreciated (I am a newbie).<br>
<br>-g.<br><font color="#888888"><br><br clear="all"><br>-- <br><a href="http://gmosx.me.gr" target="_blank">http://gmosx.me.gr</a><br><a href="http://joy.gr" target="_blank">http://joy.gr</a><br><a href="http://cull.gr" target="_blank">http://cull.gr</a><br>
<a href="http://nitroproject.org" target="_blank">http://nitroproject.org</a><br>
<a href="http://phidz.com" target="_blank">http://phidz.com</a><br><a href="http://joyerz.com" target="_blank">http://joyerz.com</a>
</font></blockquote></div><br><br clear="all"><br>-- <br>Walt Disney - "I love Mickey Mouse more than any woman I have ever known."