June 10, 2007, 02:41 PM
dballestChanging Date Separator
I need to have the date separator to be a "/" instead of a "-" in a datetime field.
TABLE FILE FILE1
STDVALUEEFFECTIVEDATE
COMPUTE TEMP3/HMDYI = STDVALUEEFFECTIVEDATE;
END
Result:
STDVALUEEFFECTIVEDATE TEMP3
2004-10-01 06:00:00 10-01-04 06:00
I need the format to be 10/01/04 06:00
Thanks in advance.
June 11, 2007, 03:21 AM
Alan BIt could be your setting of DTSTANDARD.
A setting of ON/STANDARD/STANDARDU gives ISO compatability and uses the '-' as a date seperator.
Try issuing SET DTSTANDARD=OFF to get the '/' in the date portion.