Hi,

I have a situation where I have data in two seperate fields, one as a
date field, and the other as a time field.

I would like to create a query which combines both of these with a
result in a TimeStamp field, but have been struggling with this:

I have tried the following, all without success:

Select DateField + TimeField
Select Cast(DateField as TimeStamp) + TimeField
Select Cast(DateField as TimeStamp) + Cast(TimeField as TimeStamp)

Does anyone know of a way in DBISam to combine date and time fields
together using SQL?

Thanks & Regards

Adam.

Adam


From creaking memory I think you have to form the Timestamp before casting it so untested


CAST(CAST datefield AS VARCHAR(10))+' '+CAST(timefield as VARCHAR(10)) AS TIMESTAMP)


Roy Lambert

Hi Roy,

>  From creaking memory I think you have to form the Timestamp before casting it so untested
>
>
> CAST(CAST datefield AS VARCHAR(10))+' '+CAST(timefield as VARCHAR(10)) AS TIMESTAMP)

Yup - that appears to be what I need to do. Thanks very much for your help!

Cheers

Adam.