Conversione data in SQL SERVER

[wegawhite]

Ciao, perchè questa query funziona in access e restituisce errore in sql server?:

function zweistellig(wert)
if len(wert)<2 then wert = "0" & wert
zweistellig = wert
end function

updated = right(year(date),2) & zweistellig(month(date)) & zweistellig(day(date)) & zweistellig(hour(time)) & zweistellig(minute(time)) & zweistellig(second(time))
	sql = "insert into postings (updated)"
	sql = sql & " values('"&updated&")"

Errore:

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type datetime.

:master: