convert to mysql date time

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

Apr/15/2014 05:37:01
F4SXAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
0
 
Julian HansenCommented:
Convert it where - what environment are you submitting this to MySQL from?
0
 
F4SXAuthor Commented:
is there any exact sql string for that conditions
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this would be the format:
%b/%e/%Y %H:%i%s
0
 
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.

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html
0
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.