convert to timestamp?

[dreams4000]

Hi all,

I have been able to convert dates FROM a timestamp to a normal date, but is there any way in a mysql call to convert a date stored in a database such as 2004-01-30 TO a timestamp format of 20040130000000?

I would like to be able to do something like..

...WHERE Needs_converting(some_column) = some_timestamp

any info would be cool.. thanks all

[drew010]

i suppose you could try the following,
... WHERE date_format(some_column, '%Y%m%d%h%i%s') = some_timestamp

it may not be the most efficient way but it should work.