date format

date format

i'm trying to generate a few reports from sdp, but how can i convert these data types for createddate to read as date, month and year. i tried to_Date and some other functions for date function but nothing seem to work???

in all cases, how do we make out from the bigint data type what the date actually is?????


thanks!




                  New to ADSelfService Plus?