New Years Day TimeStamp

calendar May 5, 2008 · 1 min read · mysql  ·
Share on: linkedin copy

Some work I’ve been involved with (see here and here) with UNIX Timestamps threw up another challenge today- getting the timestamp for midnight on January 1st of the current year. This is what I came up with:

SQL (using MySQL 5.5)

1mysql> SELECT UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-01-01 00:00:00'));
2+--------------------------------------------------------+
3| UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-01-01 00:00:00')) |
4+--------------------------------------------------------+
5| 1325376000 |
6+--------------------------------------------------------+
71 row in set (0.00 sec)

Excel (using Office 2003)

1=(DATE(YEAR(NOW()),1,1)-DATE(1970,1,1))*86400

Visual BASIC (using Visual Studio .NET 2005)

1Console.WriteLine(DateAndTime.DateDiff(DateInterval.Second, CDate("1970-01-01 00:00:00"), CDate(Now.Year.ToString + "-01-01 00:00:00")))