Formatting date on an INSERT

[TomBarrand]

I need to format a date into dd/mm/yyyy format when I am inserting it into the database. I am using the statement below, but this is not correct.

Any ideas?

INSERT INTO FOB (Purch_Ord_Line_No, Tracker_No, FOB_Date) Values ( 999,1,CONVERT(DATETIME, '31/12/2002', 102)

Thanks

 

[petersJazz]

This is not a general database question. Its different in every dbms. Are you using Oracle, SQL Server or?

 

[TomBarrand]

I am using SQL Server 2000. I also need to know the syntax for Informix too.

Thanks

 

[mrigankab]

TRY following code for SQL Server

INSERT INTO FOB (Purch_Ord_Line_No, Tracker_No, FOB_Date) Values ( 999,1,CONVERT(DATETIME, '31/12/2002', 103)

TRY following code for Oracle

INSERT INTO FOB (Purch_Ord_Line_No, Tracker_No, FOB_Date) Values ( 999,1,to_date('31/12/2002','dd/mm/rrrr'))

 

[TomBarrand]

I need to know the syntax for SQL Server and Informix.

Thanks