Update Record with a similar funtion to dateadd
Posted on 2006-07-13
I have a field in my sybase database that holds dates in an interger format. So for example todays date would be 13342 in that field.
I already know how to read that field in a regular date format.
select dateadd(dd, reactivate_date, '1Jan1970') from requests .....
So anything in the reactivate_date column gets returned as a proper date.
I would like to know, how would I take a proper date and convert it back to the number so I can update that particular field using the companies date structure.