Hi,

I have a table with a date column which has data in this format 2003-01-31 09:03:05.303. I would like to extract the date from this column and format it to 20030131 format. Can anyone help me how to do this.

Thanks,
Pushpa