How to insert date and time in SQL Server

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

You can't use timestamp, as this is a binary value used internally by SQL server for the purposes of unique IDs.

I played around with this a bit, trying to use a date field to hold just the time also inserted either the current date or a 'dummy' date (e.g., 1/1/1900). Therefore, unless I am doing something wrong, I would recommend using a text field to hold the current time. In VB, you can get a string with the current time through Format(Now, "Long Time") (or "Medium Time" or "Short Time")

Charlie Zimmerman
http://www.freevbcode.com

Why don't you try sendi the getdate() instruction to SQL, it will bring back the date and time

Regards