Mysql courses for BE IT students Bangalore
« on: November 10, 2011, 01:05:51 PM »
MySQL Date Functions
Built-In Date Functions In Mysql
NOW()  == Returns the current date and time
CURDATE() == Returns the current date
CURTIME()==Returns the current time
DATE()==Extracts the date part of a date or date/time expression
EXTACT() == Returns a single part of a date/time
DATE ADD () == Adds a specified time interval to a date
DATE SUB() == Subtracts a specified time interval from a date
DATEDIFF () == Returns the number of days between two dates
DATE FORMAT () == Displays date/time data in different formats

Built-In Date Functions In Sql Server:
GETDATE()==Returns the current date and time
DATEPART()==Returns a single part of a date/time
DATEADD()==Adds or subtracts a specified time interval from a date
DATEDIFF()==Returns the time between two dates
CONVERT()==Displays date/time data in different formats

Cegonsoft final year projects
« Last Edit: April 21, 2015, 04:52:22 PM by Kailash »