Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

convert to mysql date time

Posted on 2014-04-14
6
71 Views
Last Modified: 2016-06-05
how should i convert this type of dates to mysql date time

Apr/15/2014 05:37:01
0
Comment
Question by:F4SX
6 Comments
 
LVL 55

Expert Comment

by:Julian Hansen
ID: 40000902
Convert it where - what environment are you submitting this to MySQL from?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 40000910
0
 

Author Comment

by:F4SX
ID: 40001064
is there any exact sql string for that conditions
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40001069
this would be the format:
%b/%e/%Y %H:%i%s
0
 
LVL 109

Assisted Solution

by:Ray Paseur
Ray Paseur earned 250 total points
ID: 40012276
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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 4 178
Display images from mysql blob type (Not working) 9 41
Inserting data into database 10 35
Giant ibd file for our biggest table on mysql 2 17
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question