Thread: site pretime
View Single Post
Old 07-01-2003, 12:24 AM  
Junior Member
Join Date: May 2003
Posts: 4

The SQL function you're looking for is UNIX_TIMESTAMP(any sql time column).

So SELECT UNIX_TIMESTAMP(timestamp) AS timestamp FROM table; or whatever you need.

Using mysqltcl really isn't difficult (at least on *ix, I have little experience with using it on a Windrop, though I execpt it's as easy as dropping a dll in the windrop dir and loading it from the script with the 'load' command. It *should* be possible to use this module in a .itcl as well, and it might even let u use persistent connections. It's availiable here: Windows binaries here:

Oh and whoever wanted to import data from a text file, look into the LOAD DATA INFILE SQL command:
404error is offline   Reply With Quote