|
Programming C, bash, Python, Perl, PHP, Java, you name it. |
|
Thread Tools | Display Modes |
|
|||
Convert varchar () to datetime datatype in MYSQL
Hi dudes
I have a varchar something like this 'Wed Jun 17 12:06:04 2009' I would like to store into my MySql database. How to convert this varchar to datetime datatyep? Just guide me... Thanks Raj |
|
||||
Code:
mysql> SELECT STR_TO_DATE('Wed Jun 17 12:06:00 2009', '%W %M %d %T %Y'); +-----------------------------------------------------------+ | STR_TO_DATE('Wed Jun 17 12:06:00 2009', '%W %M %d %T %Y') | +-----------------------------------------------------------+ | 2009-06-17 12:06:00 | +-----------------------------------------------------------+ 1 row in set (0.00 sec) Link Last edited by anemos; 22nd June 2009 at 01:01 PM. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to convert my server to raid | revzalot | OpenBSD Installation and Upgrading | 2 | 16th September 2009 07:56 PM |
MySql on NetBSD 5.0 | Zvrk | NetBSD General | 6 | 17th August 2009 12:31 PM |
MYSQL 's fault? | disappearedng | FreeBSD General | 3 | 14th October 2008 11:53 PM |
mysql using >100% cpu | bdj | FreeBSD General | 5 | 16th May 2008 04:20 PM |