getdate conversion

[gv]

This works for SQL 2000 how would I write it for
Access 2003 query?

STUFF(CONVERT(CHAR(26),GETDATE(),22),7,2,CAST(YEAR(GETDATE()) AS CHAR(4)))

thanks
gv

 

[Roger Carlson]

Perhaps it would be useful if you explained what you are trying to do.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[gv]

I simply want to insert todays date in a insert into statement for
a spicidied column. I also wanted to insert it a certain way, like this

09/28/2005 2:31:42 PM

thanks
gv

 

[Roger Carlson]

I'm assuming you want to insert this into a text column. if spicidied was a
date column you'd just use Now().
Try this:

Format(Now(), "mm/dd/yyyy h:n:s am/pm")

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[gv]

thanks , that is what I was looking for
gv

I'm assuming you want to insert this into a text column. if spicidied was
a
date column you'd just use Now().
Try this:

Format(Now(), "mm/dd/yyyy h:n:s am/pm")

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L