Subject Inserting a date in Firebird
Author Anand
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
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
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


Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes