Re: getdate conversion

thanks , that is what I was looking for
gv


"Roger Carlson" <NO-Rog3erc-SPAM@xxxxxxxxxxx> wrote in message
news:OMO9dPGxFHA.2312@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <viatorg@xxxxxxxx> wrote in message
> news:e6D8BCGxFHA.1132@xxxxxxxxxxxxxxxxxxxxxxx
>> 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" <NO-Rog3erc-SPAM@xxxxxxxxxxx> wrote in message
>> news:udatk7FxFHA.752@xxxxxxxxxxxxxxxxxxxxxxx
>> > 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" <viatorg@xxxxxxxx> wrote in message
>> > news:%23%2302%23tFxFHA.2924@xxxxxxxxxxxxxxxxxxxxxxx
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>
>


.