Mar 10, 2011 · Learn how to easily convert UNIX Timestamps to Date/Times and vice versa in SQL Server and the simple math behind it all. (Jeff Moden)

May 12, 2021 · I have been assigned with a task that is update Timestamp column of a table upon each insert or modification of table data. As per my kowledge this can posssible in case of …

So we've started exploring using change data capture on one of our production databases. We'd like to know the datetime of each change. Reading through walkthrough's and tutorials etc it …

I have developed and published the “T-SQL Toolbox” project on codeplex to help anybody who struggles with datetime and timezone handling in SQL Server. It’s open source and completely …

Oct 27, 2017 · This return some rows, but I cannot tell which column contains a date and time. I want to know WHEN the record was inserted. The inserted record contains a TIMESTAMP …

Nov 12, 2018 · I want to get the date in DDMMYYY format from a field that stores date in YYYY-MM-DD Timestamp format. (For example, '2018-11-09' should display '09Nov2018'). I know …

Apr 17, 2007 · I have a scheduled job that takes a backup using t-sql (it's not a maint plan job). How can I automatically add the date timestamp to the end of the backup file?

Jan 27, 2015 · A clustered index on timestamp is good to maximize insert performance. I wouldn't worry about Page latch contention unless the insert rate is sustained at over 20K/sec+ or so. …

Dec 9, 2022 · I'd like to know if is possible to convert the value of a LSN. ie: 306239000001950100001 to a date/timestamp. Something silimilar of scn_to_timestamp …

Feb 13, 2012 · The query: SELECT name AS TableName, create_date AS CreatedDate, modify_date as ModifyDate FROM sys.tables order by ModifyDate; ...will tell me the last time a …