Viewing post 1 (of 2 total)
Got it figured out...
Original
substr(h.dob,5,2) || right(h.dob,2) || left(h.dob,4) as Birth_Date,
New
substr(h.dob,5,2) || '/' || right(h.dob,2) || '/' || left(h.dob,4) as Birth_Date,
...pretty easy actually.
March 15, 2010 at 3:49 pm
#1134125