Date_Format into Swatch Internet Time

[Anon]

Hi,
I just want to know how to transfer the time I get from a MySQL Timestamp to the Swatch Internet Time format.
I grab the time via the following code:

select date_format(datetime, '%d-%m-%Y - %T')

and with the "%T" I will get the time in hh mm ss format but how can I make it Swatch Internet Time?

[kaizix]

well, you'll have to figure out the algorithm to convert it but http://dcd.lattedesigns.com/internettime.shtml does it so maybe you can go through the code and take out the parts you need.

[Anon]

Uhmm... ok thanks,
I thought that there was a function for it in PHP. Thought I had seen it in the date or getdate function under the parameter "b". But that is PHP and not MySQL.

Will take a look at you link, thanks again.