Blogs about: Datetime
Featured Blog
Create a date with T-SQL
http://stackoverflow.com/questions/266924/create-a-date-with-t-sql… more →
using ...
dump network traffic with tcpdump to file with time-stamp in the filename
wrote 5 days ago: a one-liner that dumps the network traffic into a file with a time-stamp in its name: date +'%Y-%m-% … more →
TSQL SELECT Last Day Of Previous Year
wrote 2 weeks ago: SELECT DATEADD(DAY, -1, DATEADD(YEAR,DATEDIFF(YEAR, 0, DATEADD(YEAR, -1, GETDATE())) + 1, 0)) … more →
TSQL Select Jan 1st of previous year.
wrote 2 weeks ago: SELECT DATEADD(YEAR, DATEDIFF(YEAR,0 , GETDATE()) – 1, 0) … more →
Find Difference between 2 dates in Year, month, day, hour, minute, second and millisecond.
wrote 2 weeks ago: After a long time i get time to post in my blog. Few day ago i get very good function from my one of … more →
Consider Using UTC (Coordinated Universal Time) When Designing REST APIs
— 1 comment
wrote 3 weeks ago: With an ecosystem of devices that is constantly evolving, it’s hard to predict who will consum … more →
The Challenge of Writing Correct System Calls
— 1 comment
wrote 3 weeks ago: If you are a veteran of using Windows APIs, you might be familiar with some patterns. One of them is … more →
Time
wrote 3 weeks ago: Print localtime from time import strftime, localtime strftime("%Y-%m-%d %H:%M:%S", localti … more →
The case against DateTime.Now
wrote 3 weeks ago: One of the first things most .Net developers learn to do with DateTime is to get the current value f … more →
What I've been up to
wrote 1 month ago: Ok, so I know over a year has gone by, and I haven’t posted squat. Finding time for in-depth … more →
Date Logic in Sql Server 2008
wrote 1 month ago: various type of date from current date like month start date , month end date , start date of previo … more →
Date formats and conversions
wrote 1 month ago: Have you noticed how date conversions can seem a bit arbitrary at times? How a string value is trans … more →
UDF – User Defined Function – Get Number of Days in Month
wrote 1 month ago: The following UDF returns the Days in a month. It is fully functional and works with every date keep … more →
Translating Date Formats in JavaScript
— 5 comments
wrote 1 month ago: Urgh, dates. It’s always bloody dates. Whether it’s different time zones, localised formats (both … more →
PHP date convert from dd/mm/YYYY to YYYY-mm-dd
wrote 1 month ago: strtotime not work for date format of dd/mm/YYYY. So You can change dd/mm/YYYY to YYYY-mm-dd from co … more →
Date, Time, DateTime in Ruby and Rails
— 1 comment
wrote 2 months ago: There are three classes in Ruby that handle date and time. Date and DateTime are both from date libr … more →
Linq to SQL, Linq to EF, DateTime.Now and GETDATE() Woes
wrote 2 months ago: A client of ours requires that each one of their cruise ships have different timezones they exist in … more →
The Ultimate List of SQL Server DateTime Functions
wrote 2 months ago: A while back I happened upon this post by Pinal Dave, the self proclaimed SQL Authority. It is quite … more →
Turn back time
— 2 comments
wrote 2 months ago: Have you ever wished that you were able to go back in time? At least in software development that is … more →
Apache 2.2.x chroot pain #1: PHP datetime zones
wrote 3 months ago: I’m configuring a LAMP-ish (no MySQL) server on Amazon EC2 an for security reasons want Apache … more →
