Roger select dateadd(ss, <FIELD>, '1970/01/01')
Replace <FIELD> with the column that holds the date you are converting. Matt > SQL2K > > > > Can someone tell me how to convert Remedy time into a usable format, > day/time, in SQL? > > > > Thanks, > > > > Roger A. Nall > Manager, OSSNMS Remedy > T-Mobile, USA > Desk:972-464-3712 NEW > > Cell: 973-652-6723 > FAX: > sf49fanv AIM IM > RogerNall Yahoo IM > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
