converting DateSerial function from access to sql server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 31 Oct 2004 14:57 GMT

DateSerial function is not recognized by sql server
how can i convert the following function

DateSerial(Year(Date()),Month(Date()),1)

from access to sql server?

thanks

Reply to this Message

Ron Hinds - 02 Nov 2004 02:03 GMT

> DateSerial function is not recognized by sql server
> how can i convert the following function
[quoted text clipped - 4 lines]
>
> thanks

Why exactly are you doing this? SQL Server does implicit conversion of
strings that it recognizes to a datetime value:

'12-01-2004'
'2004-12-01'
'December 1, 2004'

etc.

If we knew how/why you were using it, we could possibly provide an answer...

Reply to this Message