SQL statement

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

i'm not sure which dbms you're using, but if it's mysql, check this out: http://dev.mysql.com/doc/refman/5.0/...functions.html

Please read the FAQ's about posting your DB so we don't have to guess.
How'd you get mySql out of that? ;)

mysql is the domain i most often work in, perhaps it is also the domain of the OP... i'm not hating on MS :-D