Date SQL Function

The Date() function takes a date, allows you to apply modifiers and then returns the date as UTC date. As default value it returns UTC time, which can be converted to local time in 24 hour format. 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 Date( DateTimeFormat(GetDate(), 'yyyy-MM-dd HH:mm:ss', 'en-US') ); or just the date SELECT Date( DateTimeFormat(GetDate(), 'yyyy-MM-dd', 'en-US') ); and like adding one day SELECT Date( DateTimeFormat(GetDate(), 'yyyy-MM-dd HH:mm:ss', 'en-US') , '+1 day') ; these tricks will let you use local datetime.

Syntax for Date() function is Date(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 Date('Now');
		

		SELECT Date();		
		


		/* 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');