SQLTeam.com | Weblogs | Forums

Converting Oracle to SQL dates


Like I said - I hardly do this anymore anyways...I generally just cast to DATE and the only time I will convert to a string is for a monthly period and not a generated column. If it needs to be formatted differently - or combined with other data - I let the client application do that...