Mailing List Archive


Back to the month index Back to the list index
bonnie@theodora.wcsu.ctstateu.edu
Tue, 1 Apr 1997 17:28:06 +0500 

From: bonnie@theodora.wcsu.ctstateu.edu
Date: Tue, 1 Apr 1997 17:28:06 +0500
Message-Id: <9704012228.AA01219@theodora.wcsu.ctstateu.edu>
Subject: [mSQL] dates in msql2B5

OK, I'm stumped. What is the date format in the beta 5?
I've tried everything I can think of.

[libmsql] Query = "insert into treats values('112','1111','flease',33.45,'1996-10-11')

ERROR : Invalid date format "1996-10-11"
----------------------------------------------------------
[libmsql] Query = "insert into treats values('112','1111','flease',33.45,'1996/10/11')

ERROR : Invalid date format "1996/10/11"
---------------------------------------------------------
[libmsql] Query = "insert into treats values('112','1111','flease',33.45,'10/11/1996')
"
ERROR : Invalid date format "10/11/1996"

and so forth...

What is the correct syntax? The ones above are those shown in
the only handy SQL reference I could find.

                                        Bonnie MacKellar
                                        bonnie@theodora.wcsu.ctstateu.edu
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!