**
Hello Antonio,
Without giving any db-specific syntax, you should be able to
accomplish this conversion as follows:
- Add or subtract your GMT offset (in seconds) from the integer
value stored in the database for the date/time
field (the offset may be different depending upon what part of the
year the given date falls under -- daylight saving time or standard
time).
- Divide the value from the first operation by
86400 (the number of seconds in one day) and drop the remainder. This
will give you the whole number of days since January 01, 1970 12:00:00 in your
local time zone.
- Add the value from the first operation to the integer value
2440588. This is the integer value for January 01,
1970, for a Remedy date field. The result of the addition should be the
correct converted value for the date
field.
I think you could also accomplish this via an escalation
without triggering other filters, by using a filter with a "Goto" action to
bypass the execution order of your other filters.
HTH,
Thomas
----- Original Message -----
Newsgroups:
gmane.comp.crm.arsystem.general
Sent: Monday, October 09, 2006
10:56
Subject: Move Date/Time Field value to a
date field using SQL
Hello Lister,
I`m in the process to move the values
stored in a date/time field to a new one in the date field
format.
In the form exist at leats 1.000.000 records and I prefer to
perform this updade via sql in order to not activate the filters defined
over the form if I use an escalation.
Is there any way to
accomplish that?
Any hints will be really appreciate.
Thanks in
advanced
Antonio Acosta Consultant Caracas -
Venezuela
__20060125_______________________This posting was submitted with HTML in it___
|