DATETIME

Hi,

I have a date time field called LH_TIME_IN.

I want to create a field next to this that is a datetime field with the same date as LH_TIME_IN but i want the time to be midnight (00:00:00:000)

Can anybody help

ive tried (LH_TIME_IN + '00:00:00:000') but this gives me the same time as LH_TIME_IN

May 21st, 2015 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics