Converting the data/date to Mysql/string format

[Matt]

Hello,

i have the following 

SfDateTimeEdit 

DateTimeEditingMode = Mask

DateTimePatter = Custom

Format = dd/MM/yyyy H:mm

i am trying to convert to Mysql readable yyyy-mm-dd hh:mm:ss

but it doesnt allow me to get the correct time when converting

the code i have is 

Dim date As String = Convert.ToDateTime(SfDateTimeEdit3.Value).ToString("yyyy-MM-dd H:mm:ss")

it converts fine if the editing mode is default but i then cannot rely on the user putting the : between causing it to default to 00:00

Any help on this matter would be fantastic. 

[Arulraj A]

Hi Matt, 

Thanks for using Syncfusion product. 

We have analyzed your requirement. In SfDateTimeEdit control, we need to set the Value as DateTime.Now for showing the current DateTime in the Custom DateTimePattern. Please make use of the below code snippet. 

C# 

this.sfDateTimeEdit.DateTimeEditingMode = Syncfusion.WinForms.Input.Enums.DateTimeEditingMode.Mask; 

this.sfDateTimeEdit.DateTimePattern = Syncfusion.WinForms.Input.Enums.DateTimePattern.Custom; 

this.sfDateTimeEdit.Format = "dd/MM/yyyy hh:mm:ss"; 

 

this.sfDateTimeEdit.Value = DateTime.Now; 

 

Please make use of the below screenshot for your reference. 

Sample: SfDateTimeEdit_Sample 

 

Screenshot 

 

Please check the above solution and let us know if it is helpful. 

Regards, 

Arulraj A 

[Matt]

Hello,

Thank you.

i in the meantime worked out the issue.

it was because allow Null was True.

once i had switched to False it worked with the original code. 

[Arulraj A]

Hi Matt,

Thanks for the update.

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you.


Regards,
Arulraj A