[thelist] MySQL database time..

Anthony Baratta Anthony at Baratta.com
Fri Mar 30 15:56:37 CST 2001


At 01:38 PM 3/30/2001, you wrote:
>Hi-Ho -
>
>Coming from the Oracle side of things, I'm getting my feet wet with
>MySQL. My problem is this:
>
>In Oracle, I used to be able to get the current database date/time with
>'sysdate' ala, update table set time='sysdate';
>
>Is there anything comparable in MySQL? I skimmed(and am currently
>skimming) through the MySQL doc's but haven't found anything yet..

NOW() ???

GETDATE() ???

Or am I off base here?



---
Anthony Baratta
President
Keyboard Jockeys





More information about the thelist mailing list