I have few tables with various datetime columns in a SQL Server 2008 database. These tables are updated (inserted/updated/deleted) through stored procedures. So for datetime columns, insert or update happening with current timestamp returned from getdate() function. But for few of the cases, the timestamp getting saved something like "2013-09-23 00:00:00.000". For some reason, the time part is completely missing in the current timestamp returned by GEtDATE function but not always for all inserts or updates. Did anybody face any such issue before with SQL Server 2008 DB? If YES then what was the root cause of this issue and what was the fix?