I may not be remembering correctly, but I think the delimiter for a date value is the pound sign '#' so try #2004-03-18# If nothing else, use the date() function to convert date("2004-03-18") HTH, Charles > -----Original Message----- > From: michaelr_41@xxxxxxxxxxxxxx [mailto:michaelr_41@xxxxxxxxxxxxxx] > Sent: Thursday, March 18, 2004 4:11 PM > To: Midrange Systems Technical Discussion > Subject: SQL Timestamp Default > > > How do you specify a date for a default value with a > timestamp variable? > I've tried combinations of > > STARTDATE TIMESTAMP WITH DEFAULT "20040318" with the defauly value > surrounded by apostrophes, quotes, and with and without dashes... > > What am I missing? > -- > > michaelr_41@xxxxxxxxxxxxxx > > -- > http://www.fastmail.fm - Access all of your messages and folders > wherever you are > _______________________________________________ > This is the Midrange Systems Technical Discussion > (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. >
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.