Small SQL help

mark_tim1999 · #1 (**permalink**) 05-24-04, 10:18

how do we convert YYYY-MM-DD format to Mon.,dd,yy format?
2004-14-04 to Apr.,14,04

dsusendran · #2 (**permalink**) 05-24-04, 11:48

Visit:

http://www.cs.ucla.edu/classes/winte...1/DB2Time.html

Hope this helps

Newbie

Marcus_A · #3 (**permalink**) 05-24-04, 14:32

There is no built-in SQL function to do that. You might look at the supplied DB2 functions or write one yourself. You would probably need the CASE statement.

J Petruk · #4 (**permalink**) 05-25-04, 08:08

Quote:

Originally Posted by mark_tim1999

how do we convert YYYY-MM-DD format to Mon.,dd,yy format?
2004-14-04 to Apr.,14,04

Use the DAY(), YEAR(), and MONTH()/MONTHNAME() to extract the pieces, and concat them together how you'd like them.

Internet Services

Web Development

Digital Marketing

Consumer Tech