converting DateSerial function from access to sql server

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
Sam said:
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
Click to expand...

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