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

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

2008-11-18 Thread Markus Hoenicka
Ken Ramsay writes: time = dbi_result_get_uint(result, UNIX_TIMESTAMP(HIST_Timestamp)); Without actually trying the code: one rough guess is that MySQL does not return the timestamp as an uint value but as something longer. Did you try using dbi_result_get_field_type() and