date functoid

hai friends,
I have a simple problem.
I want to insert current date to SQL table which has a column \”date\” with type smalldatetime.To do this I used date functoid in the map.
But it gives me a error depassement of capacity for datatype smalldatetime but when i change SQL column \”date\” datatype to varchar it works well.

Is the date value returned by date functoid can be inserted into SQL column datatype \”smalldatetime\”?

Can anybody help me?
Thanks in advance.

kavitha