convert to mysql date time

how should i convert this type of dates to mysql date time

Apr/15/2014 05:37:01
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Julian HansenCommented:
Convert it where - what environment are you submitting this to MySQL from?
F4SXAuthor Commented:
is there any exact sql string for that conditions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this would be the format:
%b/%e/%Y %H:%i%s
Ray PaseurConnect With a Mentor Commented:
I find this sort of thing easier to do in PHP.  So if you have PHP available, this article will tell you everything you need to know about date/time conversions.

You may want to pay particular attention to the ISO-8601 date/time format.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.