Subject Fundamental of DATE type
Author Yosi

I have a problem here, I have inserted a lot of record into my table from many processes which is one of it's field is a DATE type. The problem is about the DD and MM formatting, I am inserting using this Syntax

Insert Into TABLE (dtreceive, price, ID) values ('9/1/2003', 23000, 2);

I mean convert the date data from a String '9/1'2003' to input in MM/DD/YYYY format, but a lo of the data is reversed in DD/MM/YYYY.

I want to know how's the most efficien way to input into the table so I will never worry about the format sequences again.

Thx ....

[Non-text portions of this message have been removed]