Weird date thing

[mousematt]

Hi,
Need some help with a strange date thing.
Am using this below;

INSERT INTO Deliveries (DelInfo,DelDate,PostedBy,PostDate)VALUES('test',14/05/2004,'Matt',16/04/2004)

But the dates keep going into the table as 01/01/1900. Any ideas why??

 

[JayKusch]

INSERT INTO Deliveries (DelInfo,DelDate,PostedBy,PostDate)VALUES('test','14/05/2004','Matt','16/04/2004')


Thanks

J. Kusch

 

[mousematt]

Do dates need ' ' then??

 

[mousematt]

Just comes up with this now.

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated."

The field its going into is datetime

 

[JayKusch]

INSERT INTO Deliveries (DelInfo,DelDate,PostedBy,PostDate)VALUES('test','5/14/2004','Matt','4/16/2004')


Thanks

J. Kusch

 

[NathanGriffiths]

or

SET DATE_FORMAT dmy

INSERT INTO Deliveries (DelInfo,DelDate,PostedBy,PostDate)VALUES('test','14/05/2004','Matt','16/04/2004')

 

[NathanGriffiths]

Sorry, should be

SET [b]DATEFORMAT[/b] dmy

INSERT INTO Deliveries (DelInfo,DelDate,PostedBy,PostDate)VALUES('test','14/05/2004','Matt','16/04/2004')