Timestamp -> getdb

rupaln

Is there a way to retrieve a Date field using getDB? Coz when I use the below statement it retrieves a null value:
_assertEqual("10/11/2010 12:00:00.000000 AM" , $rs1[0]["HEARING_DT"].getTimestamp);

The retrieved value for $rs1[0]["HEARING_DT"] is "2010-10-11.0.0. 0. 0" vs. "10/11/2010 12:00:00.000000 AM"

I have tried to parse it, but doesn't help...

Any suggestions, would be helpful

Thanks,

narayan

$rs1[0]["HEARING_DT"] will be returned as a string. Have a look at this post for getting differently formatted dates.

http://sahi.co.in/forums/viewtopic.php?id=1159

rupaln

I had to substring the Dt before using the formatter function specified...

Thanks,