pcsoft.us.windevCopyright 2026, PC SOFT24 Apr 2015 09:02:00 Z23 Apr 2015 09:42:00 ZHello to all I have a MySql database hosted on a Unix machine, created by an old programmer who is working in our firm. I'm able to access to this db and its tables and extract all the values stored on it. But, i have a field called "call_date" definied as INT and i need to extract the date/time stored with this format. Googling i found a Sql solution to see the correct date/time and i have to write: SELECT FROM UNIX_TIME (call_date) and the readeable date/time is shown. I thought "IntegerToDate" was the solution, but i have an error during the execution. Is there someone who can tell me how to obtain the converted date and time from this INT format?? Thanks in advance Gianni30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51762/read.awp24 Apr 2015 09:02:00 ZHi to all Found the solution... the basic formula is: (UniDateInt/86400)+25569+(1/24) (1/24) is for Italian timezone …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51762/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51762/read.awp[WD17] Convert Date from Unixguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51748/read.awp23 Apr 2015 13:45:00 ZHi Gianno, sure there is.. just google unix time integer format and you'll ind all the information you need... From a quic…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51748/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51748/read.awp[WD17] Convert Date from Unixguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51745/read.awp23 Apr 2015 12:55:00 ZIt looks like your int is the number of seconds since '1970-01-01 00:00:00' UTC Add your int value to the seconds of a datetime…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51745/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51745/read.awp[WD17] Convert Date from Unixguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51744/read.awp23 Apr 2015 12:38:00 ZHi Paulo Yes, i know what you say. But, i'm reading records using Hreadseek and not doing a SELECT. I was hoping there wa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51744/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51744/read.awp[WD17] Convert Date from Unixguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51740/read.awp23 Apr 2015 10:23:00 Zif you can get the date/time with the select you mention why don't you use it to get the values you need? did you try to execut…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51740/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51739-wd17-convert-date-from-unix-51740/read.awp[WD17] Convert Date from Unix