Dear All,

Please guide me how to insert current date in one field and current time in another field in SQL server. I used CAST, it works with date (It works but I am not clear) but not work at all with time.
I selcted smalldatetime for date and timestamp for current time storage.

regards,

Santulan