Converting Date Field Type

[gkrenton]

I'm creating a view that uses a field that is in a DATE layout, yet the date field I'm interfacing this data to is in a DATETIME layout.
I can't find anything that explains how to convert a field from a DATE layout to a DATETIME layout.

Any help is appreciated.

Thanks

Gina

 

[olded]

Use the extend keyword. Given my table c_shiftacc has a column shiftdate of type date:

select extend(shiftdate, year to second) from c_shiftacc

my data displays as such:


2005-06-01 00:00:00
2005-06-01 00:00:00

 

[gkrenton]

That works! Thanks a ton. Figured it could be done but not obvious in any of the books/manuals I have running around here.

-Gina