Re: [SQL] merging date and time

On Wed, Mar 31, 1999 at 10:01:20AM -0600, Ross J. Reedstrom wrote:
> test=> create table t1 (d date, t text);
> CREATE
> test=> insert into t1 values('22-03-1999','14:45:27');
> INSERT 101293 1
> test=> select datetime(d+timespan(t)) from t1;
> datetime                    
> ----------------------------
> Mon Mar 22 14:45:27 1999 CST
> (1 row)
> 
> test=> drop table t1;
> DROP
> test=> 

Or more simply...

select ('22-03-1999'::date + '14:45:27'::timespan) as myDateTime;
mydatetime                  
----------------------------
Mon Mar 22 14:45:27 1999 GMT
(1 row)


-- 
If at first you don't succeed, skydiving is not for you...