How to convert month string into date

Yukke · #1 (**permalink**) 10-12-07, 09:50

I want to take a string representation of month and convert it to a date format.

For example:
'July' -> '2007-07-01 00:00:00.0'

Thanks

ARWinner · #2 (**permalink**) 10-12-07, 12:56

You will have to write your own UDF.

Andy

Peter.Vanroose · #3 (**permalink**) 10-14-07, 13:18

Suppose your string repr. of month name is in "month_name"; then

Code:

VALUES(
 CASE month_name
  WHEN 'July' THEN DATE('2007-07-01')
  WHEN 'January' THEN ...
  WHEN ...
  ...
  ELSE CAST(NULL AS DATE)
 END)