yahoo invisible

Wednesday, January 21, 2009

Sql vs oracle

How to convert a date figure to a string in sql and oracle

sql ------------------>CONVERT(varchar, Column_DATE, 103) AS [Application Date]
oracle---------------->to_char(Column_DATE,'dd/MM/yyyy') "Application Date"

posted by Milindanath @ 1:55 AM

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home