Hi:
I need is there a way to convert the bigint(20) date fields in Infolog (Mysql) tables from the integer to a standard date time format with out using the dateadd function?
I need to generate a query result using a standard date format. I get an error when I try to use the following SELECT query:
Select info_startdate, dateadd(ms, info_startdate-(info_startdate/1000)1000, dateadd(ss, info_startdate-(info_startdate/1000+860*60, ’ 19700101’)) from egw_infolog limit 2, 4
Can’t I also use the Convert function with some tyoe of query like: SELECT CONVERT (BIGINT(20), info_startdate, 10) from egw_infolog…?
I tried this and received an error also.
I just want to convert from a bigint integer to a regular date format for a SELECT query.
Any help is greatly appreciated. Thanks.
