TIMESTAMP to DATE and more

[dominant]

I have long to get instructed from the Mysql Manual so i discovered that many functions (regarding TIMAE & DATE) are introduced in Mysql 4.1.1.

I have mysql 4.0.15-Max

and i want to convert a TIMESTAMP to DATE (YYYY-MM-DD)

I also want to substart 2 TIMESTAMP types

Thanks in advance.

[dopey]

and i want to convert a TIMESTAMP to DATE (YYYY-MM-DD)

Something along these lines should do it...

select date_format(myTimeStampColumn,'Y-m-d') from myTable;

I also want to substart 2 TIMESTAMP types

Sorry, not sure what you mean?