I got it for the first string conversion
FORMAT 'mmmBddByyyyBhh:miT'
Aug 29 2007 10:45PM (FORMAT 'mmmBddByyyyBhh:miT')
when i did something similar for the second one
08/30/07 10:45:00 PM (FORMAT 'mm/dd/yyBhh:mi:ssBT')
i got 1907-08-30 22:45:00 as the output.
is there a way to get it as 2007-08-30 instead of 1907-08-30
Thanks