>Hi Kerwan
>
>Try it this way, shouldn't be hard to miss.
>
>

?sqlexec(nHandle,'INSERT INTO X (date) values (' + FBDTOS({01/01/2005}) + ')')
>?sqlexec(nHandle,'INSERT INTO X (date) values (' + FBDTOS(DATE()) + ')')
>
>FUNCTION FBDTOS(tdDate)
>	RETURN "'" + TRANSFORM(YEAR(tdDate), "@L 9999") + "-" ;
>		+ TRANSFORM(MONTH(tdDate), "@L 99") + "-" ;
>		+ TRANSFORM(DAY(tdDate), "@L 99") + "'"
>ENDFUNC

Bhavbhuti,
Seeing ppl suggesting ways like this I wonder if FB doesn't support usual parameter passing? ie:

myDate = {^2005/1/1}
?sqlexec(nHandle,'INSERT INTO X (date) values (?m.myDate)')

It would be the first backend I hear that doesn't support it.

PS: RETURN "'" + TRANSFORM(dtoc(m.tdDate,1), "@R 9999/99/99") + "'"
Cetin