Getting current time in milliseconds.

[tduraipkt]

In MySQL ::
select CURDATE();
It will return currentdate in YYYY-MM-DD format. But i need the corrosponding milliseconds value. What is the query to get this value?. And what is the query to get current time(milliseconds value) in MSSQL?.

[chazzy]

you can use NOW() to get the current date and time. you can use the date_format function to format it to a UNIX timestamp.

I don't think it's going to get as low as MS though..