Tags » Datetime

SQL Server - SYSDATETIME() versus GETDATE()

From SQL Server 2008, the datetime2 datatype was introduced, with greater flexibility for precision and also with an added bonus that it was truly compliant with ANSI and ISO 8601.   249 more words

SQL Server

Sage 300 Date Utility

Introduction

Microsoft’s DateTime Structure is an object that represents an instant in time, typically expressed as a date and time of day.

In Sage 300’s Web Screens, we use this object for dates and times in our C-Sharp code. 553 more words

Sage 300c

Oracle's INTERVAL Datatype Basics & Usage Examples

Oracle “Interval” data type is a new data type that was introduced in version 9i.

In simple, terms, prior to 9i, if one needed to find the “duration” between a start time and end time, the query syntax was not too awkward but results were not human friendly. 595 more words

Oracle

Date time format in Ruby

The most common uses of date time format in Ruby for reference Code Output Description t.strftime(“%H”) => “22” # Gives Hour of the time in 24 hour… 174 more words
Datetime

Limerick Short Film Flies with AerLingus

Following their recent successful broadcast screenings, one of the three short films of the Film Limerick Trilogy, DATE:TIME, is now currently screening on Aer Lingus flights to and from the USA. 53 more words

Film

Time zones in Java 8 Date and Time API

Introduction

I know for a fact that all programmers love working with time zones. Chances are high that you, as a reader of this blog, are also a programmer so I bet you also just love time zones. 526 more words

Java

How to get a current date in a specific time zone on Azure with c#

One simple DateTime.Now could become a big headache when you run your application on clound(e.g. Azure) and you need to know about the server location settings. 74 more words

C#