I want to insert a date value in a table. What is the best way
to do it?
For current date and time I can simply add the string
"Current_TimeStamp" in
the query and be done. The shortcoming of this method is the
code will not
be portable. A more serious problem is with arbitrary date
values.
We are using Delphi to build the front-end and the method
described there to
retrieve the local date settings of the system and formatting
your date as
per those settings is so tedious, I decided to opt for this
question
instead.
In short, if I format my date in the format "mm/dd/yyyy", how
would I insert
this date into a table, making sure the date is correctly
interpreted by the
database?

-
Anand



__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus