Parse a Date

[timmbo]

Hi All,

I need to find the best way to take a date and reformat it as yyyy/mm/dd. I'm retrieving begDate, (current format is mm/dd/yyyy), from my jsp page.

myStmt = myStmt + "And to_char(detail.as_of_date, 'yyyy/mm/dd') >= '" + Format(begDate, "yyyy/mm/dd&quot + "' ";

Any help would be appreciated.

Thanks,
Tim

 

[timmbo]

I answered my own question. Thanks everyone.