DateTime SQL Function

The DateTime() functions takes a date and allows you to apply modifiers and then returns the date as UTC date or time. As default value these functions return UTC time, which can be converted to local time in 24 hour format e.g. SELECT DateTime('Now', 'localtime'); For .Net style date time and more control see getdate() , GetUTCDate() , DateAdd , DateDiff() and DateTimeFormat() functions. To work with Local Date Time you can use DateTimeFormat function e.g. SELECT DateTime( DateTimeFormat(GetDate(), 'yyyy-MM-dd HH:mm:ss', 'en-US') ); or just the date SELECT DateTime( DateTimeFormat(GetDate(), 'yyyy-MM-dd', 'en-US') ); and like adding one day SELECT DateTime( DateTimeFormat(GetDate(), 'yyyy-MM-dd HH:mm:ss', 'en-US') , '+1 day') ; these tricks will let you use local datetime.

Syntax is DateTime (Date or timestring , [ modifier1, modifier2, ... modifier_n ] )
A Date or timestring value and modifier1, modifier2, ... modifier_n are optional. Modifiers that are applied to the date time string are applied in order and are cumulative.

		/* Following will output UTC Date Year-Month-Day or YYYY-MM-DD */ 

        SELECT DateTime('Now');
		

		SELECT DateTime();
		


		/* Following will output UTC Time as Hour:Minutes:Seconds */ 

        SELECT DateTime('Now');
		

		SELECT Time();
		


		/* Following will output Complete UTC Date and Time */ 

        SELECT DateTime('Now');
		

		SELECT DateTime();
		


		/* Following will add a day in UTC date time */ 

        SELECT DateTime('Now', '+1 Day');