Format Date

I want to insert today's date into database. The date format must be something like this 02 September 2004

How can I write sql ? I tried
dim d
d=formatDateTime(Date,1)
sql="insert into datagraph(dat ) values('"&d&"')"

But the result is Thursday, September 02,2004. It doesn't what I want.
I want 02 September 2004 .

I am so so ....tired with sql !! :-(You may want to pose this question in the forum for your specific DBMS, so that the date format can be addressed for that system.