The format used for date/time values can not be earlier than this date/time. If you need this capability, use a date data type instead of a date/time data type.
Axton Grams On 3/7/07, Tyra Nunn <[EMAIL PROTECTED]> wrote:
** 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"
