Figured it out... STARTDATE TIMESTAMP WITH DEFAULT '2004-03-18-00.00.00' Bleah... On Thu, 18 Mar 2004 16:11:11 -0500, michaelr_41@xxxxxxxxxxxxxx said: > 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. > -- michaelr_41@xxxxxxxxxxxxxx -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.