This depends heavily on your particular database. You should probably check
your database's docs, or a mailing list specific to your database if there is
one.
In some databases, "date" may be a reserved word and therefore not eligible to
be used as a field name.
Do you want your field to have the date/time of the insertion, of the most
recent update, or do you want it to return "now" every time you select from it?
--Wes Sheldahl
"Nguyen, David M" <[EMAIL PROTECTED]> on 09/05/2001
01:04:39 PM
To: [EMAIL PROTECTED]
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: date/time system format
How do I create a a field to use system date, is the code below correct?
What I want is the system will generate system date/time for me
automactically without user's input.
SQL> create table calllogtest
(date sysdate(8));
Thanks,
David
