format date

[nitindel]

Hi can u please let me know that :

i am using datetime as the datatype...

and it is returning the time like :
2/19/2008 11:32:01 PM

but i want to display it in
19 February 2008


please let me know

Thanks

[eclypz]

Hi can u please let me know that :

i am using datetime as the datatype...

and it is returning the time like :
2/19/2008 11:32:01 PM

but i want to display it in
19 February 2008


please let me know

Thanks

Hello,

I think u can solve that if u use something like Format([dateField];"dd mmmm yyyy")

Best regards,

[amitpatel66]

Hi can u please let me know that :

i am using datetime as the datatype...

and it is returning the time like :
2/19/2008 11:32:01 PM

but i want to display it in
19 February 2008


please let me know

Thanks

Try this:

CONVERT(CHAR(11 ),GETDATE(),106 )

[nitindel]

Hello,

I think u can solve that if u use something like Format([dateField];"dd mmmm yyyy")

Best regards,

Thank a lot....!!!
dear

I used...

CONVERT(CHAR(11 ),date,103)

Thanks