convert VARCHAR to TIMESTAMP?

82 posts
[expired user #1919]'s profile image [expired user #1919] posted 16 years ago in General Permalink
date = VARCHAR (30) current format 3 October 2008
How would I convert a VARCHAR to a TIMESTAMP along with the data.

Cheers
127 posts
[expired user #1125]'s profile image [expired user #1125] posted 16 years ago Permalink 
select
unix_timestamp(
str_to_date(
'3 October 2008',
'%e %M %Y'
)
) as mytimestamp
;
82 posts
[expired user #1919]'s profile image [expired user #1919] posted 16 years ago Permalink
Wow that's neat, except it only works with the text entered and not the actual database field.
I asked without thinking.
table;
ID; DATE; NAME; PHOTO
data;
1, 3 October 2008, blah blah blah, Y

Please login to leave a reply, or register at first.