Re: Saving dates as YYYYMMDD

[Christian Mack]

"Claudia M. Castaneda" wrote:
> 
> Is it possible to have the DB save the date as YYYYMMDD and the time as
> HHMMSS using the date and time types respectively and not return a
> formated string, i.e "YYYY-MM-DD" or "HH-MM-SS" ?
> 
> ---
> Claudia M. Castaneda

Hi Claudia

Thats easy :)
CREATE TABLE time_table (date_field DATE, time_field TIME, datetime_field DATETIME);
INSERT INTO time_table VALUES( NOW(), NOW(), NOW() );
SELECT date_field + 0, time_field + 0, datetime_field + 0 FROM time_table;

Tschau
Christian