|
I think it is CURRENT_DATE, or in the case of timestamp CURRENT_TIMESTAMP Hauser, Birgitta wrote:
Hi Don, The default value for a NOT NULL Date-Field is '00001-01-01' Birgitta -----Ursprüngliche Nachricht----- Von: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Don Gesendet: Dienstag, 4. Oktober 2005 15:04 An: midrange-l@xxxxxxxxxxxx Betreff: Dumb SQL question...Anyone know off hand what the default of a NOT NULL on a DATE field is in SQL?thanks... Don in DC
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.