Subject Re: [firebird-support] Insert a data value
Author Stefan Heymann
I always use this format:

'29-MAY-2006 16:11:27'

Months in English: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT,

There is a special date 'NOW' which is, believe it or not, now :-)

Best Regards


> Hi,
> in access database i use this DataString value to INSERT a new record,
> for DATE field (taken from a combodata.value)

> DataString = "#" & Format$(ComboData.value, "yyyy/mm/dd") & " 00.00.00#"

> Now in FB2 i receive a conversion error from string
> which is the correct string to pass to insert to correctly insert a DATE value ?

> thanks
> Adriano

Stefan Heymann