changing unxitime into datetime

pipo · Post by **pipo** » Sat Jan 13, 2007 2:39 pm

uhm dont know if this the right forum to ask this...

I have stuff stored in a .txt file with unixtime format, like 1163894721

Now I have a new script that stores everyting in a mysqldb in datime format like: 2007-13-01 19:40:23

Now my question is, is it possible to change the unxitime from the .txt file into datetime, so i can load it in the mysqldb?

If yes, how can I do that?

Thanks.

rosc2112 · Post by **rosc2112** » Sat Jan 13, 2007 5:14 pm

Check the [strftime] command and your unix manpage for strftime formats.