SQL Package vs Date field

Ask the community
,
1

I am looking for an example of code of a SQL statement using date field. What format should be the date.

Using only a new Date() value is not working within a SQL statement
Thanks.

2

Hi Youge, there is currently no native support for date type inputs.
One thing you can try is to cast the date value as a string, if this supports your use case. So for example, something like that would work:

sql ( INSERT INTO Table (title, date) VALUES ('title', ${ JSON . stringify ( **new** Date ())} ) );

Good luck.