Insert the date into MySQL

Submitted by ghada45 on Thu, 08/20/2015 - 17:19
1
0
-1

Hi,
I'm using BOS 6.5.1 and MySQL and they don't have the same format of date,
so my problem is, how can i get the date from the widget and save it on the Data Base??
PS: i'm newbie , so please describe your solution with details.

Thank you very much for your time and your attention.

1 answer

Submitted by Sean McP on Fri, 08/21/2015 - 11:02
1
+1
-1

You get the date from the screen and then do a piece of java code in the output operation and then send it to the DB.

Your form has a datepicker.

in your process you set the output operation (click on the pencil to edit the script), use this to transform the datepicker date to mysql date as a new variable (java/groovy code).

then use this variable in your SQL statement

regards

Notifications