Re: [libdbi-users] UNIX Timestamp - DATE to UTC conversion

2008-11-19 Thread Toby Thain
On 19-Nov-08, at 8:42 AM, Ken Ramsay wrote: Thanks guys, MySQL defines the field as a DATETIME , so the return type is time_t. No; you are using an expression, not the column, so the result type is indeed BIGINT, as Markus surmised (his explanation was correct, as far as I can

Re: [libdbi-users] UNIX Timestamp - DATE to UTC conversion

2008-11-18 Thread J.J.Green
Ken Shouldn't you have a time_t (unsigned long) for the time return type (and a dbi_result_get_long or whatever to extarct it)? On Mon, 17 Nov 2008, Ken Ramsay wrote: Guys I am trying to get info from a mysql database that stores the date in a string format and return UTC format as well as