| Subject | Re: [firebird-support] How to combine date and time? |
|---|---|
| Author | Claudio Romero |
| Post date | 2010-02-18T13:50:11Z |
May be this?
Date + Time =TimeStamp
( date ->string ) + (time ->string) = timestamp
SELECT cast(CAST(a_date as varchar(13))||' '||CAST(a_time as
varchar(13)) as timestamp)
FROM LOG_INGRESOS_SALIDAS;
Regards
Date + Time =TimeStamp
( date ->string ) + (time ->string) = timestamp
SELECT cast(CAST(a_date as varchar(13))||' '||CAST(a_time as
varchar(13)) as timestamp)
FROM LOG_INGRESOS_SALIDAS;
Regards