SQL - date field into a datetime field

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

Is there an easy way to do this?

I have a DDS file with a 'date' field.   Type 'L'.

However a pc program needs to see the value in a datetime value.

I do not have the source code for the PC program, so I cannot do a convert.to(datetime

But I do have access of the SQL command to retrieve the data from the as/400.  Is there a way to transform via sql a date field into a datetime field I'm ok setting the time to midnight or some other arbitrary number.

Thanks, Tim





Think Green! Please do not print this e-mail unless you need to. Thank you.


------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain 
confidential or privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the 
sender by reply e-mail and destroy the message.


==============================================================================