Tyra, If you need to store a date prior to the Unix epoch, Remedy ARS versions 5.1 and higher include a date field type that accepts dates as far back as January 1, 4713 B.C. The database stores this as the number of days since the start of this period.
--Thomas ----- Original Message ----- From: Tyra Nunn Newsgroups: gmane.comp.crm.arsystem.general To: [email protected] Sent: Wednesday, March 07, 2007 12:18 Subject: Fwd: Remedy ARS and the UNIX Epoch ** Has anyone had any issues with this? Tyra Nunn Remedy Application/Administrator 312 8th Ave 17th Floor Nashville, TN 37234 615-253-3113 Office 615-498-1378 Cell [EMAIL PROTECTED] Email >>> Bruce Zimmer 03/07/2007 11:51 AM >>> Hey Tyra, Have you had any problems with Remedy ARS and the UNIX Epoch? Solaris stores the time/date as the number of seconds since midnight on January 1st, 1970 (the "epoch"), or 01/01/1970 00:00:00, and that's what Remedy uses to calculate dates and times. For example, we're seeing some problems in our employee table when an employee's hire date is prior to the epoch, so that date filed is considered an invalid value. Dates after the start of 1/1/1970 are okay. Thanks, BZ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
