Hello
I am reading String value as varchar from File and i need to convert that string to Date.
My input String =01-MAR-2008
My output should be=01-03-2008
Is there any functions other that StringtoDate.
Thanks
String toDate conversion
Moderators: chulett, rschirm, roy
So your output is yet-another string or is it actually a Date field? For the former you'd need to combine StringToDate() with DateToString() to get the desired external representation of the date. Only the former is needed for the latter, if that makes sense. Meaning, you only need the StringToDate() function if your target is a Date field.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers