converting DateSerial function from access to sql server

[Sam]

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

 

[Ron Hinds]

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

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...