System TimeStamp

[anvi kon]

How would I get the System timestamp in MYSQL?

I have done like below.

SELECT now();

But it does't give exactly my System datetime.


thanks

[Jeanne Boyarsky]

Anvi,
Now is correct. What do you mean that it doesn't give you exactly the current timestamp? How much is it off by?

[ahamed irshad]

you can use this query

select sysdate from dual

[Jan Cumps]

ahamed irshad wrote:you can use this query

select sysdate from dual

Does that work for MySQL?

[Fatih Keles]

Hi anvi,

Do you use "now()" function in a trigger or procedure? "Now" does return the exact time that triggering event started, unlike "sysdate()". If you need to get the exact time when the now/sysdate line is executed you should use "sysdate()".

You may take a look at the manual.

Regards,

Fatih.

[ahamed irshad]

i mean sysdate() only

[ahamed irshad]

try this link


http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now