Re: Need help Datefield Retrieval like this mmddyyyy

[Jimmy Liao <chien-wei.j.liao@AC.COM>]

Dominick,

I'd use the extract command

For example: (assuming your start date is in the form of yyyy-mm-dd

Begin-select
start_dt  &start_date
End-select

extract $start_yyyy from &start_date 0 4
extract $start_mm from &start_date 5 2
extract $start_dd from &start_date 8 2

let $start_date = $start_mm || $start_dd || $start_yyyy

Hope this helps!
-Jimmy



>Say I have a field called start date on a oracle db
>I want to retrieve in like this mmddyyyy
>How would I do this with sqr
>Thanks