Category: sql-server

Daylight savings time in Sql Server

Post author By user user
Post date February 19, 2022
Categories In sql, sql-server, time
3 Comments on Daylight savings time in Sql Server

We’re using an old application that stores dates in C / Unix format. C time is basically the number of seconds since Jan 1st, 1970. The dates are stored as an integer in a SQL Server database. I am writing a view for a report that uses these dates. So far, I’m converting from the […]

TSQL query that would return me the earliest date and the latest date in a table

Post author By user user
Post date February 19, 2022
Categories In sql, sql-server, sql-server-2008, tsql
3 Comments on TSQL query that would return me the earliest date and the latest date in a table

I have a table in a sql server 2008 database that contains bunch of records as well as a date column. The date is inserted automatically when a new entry to the table occurs. So, it contains the date of the record that has been created. I am trying to run a query that would […]