Mysql courses for BE IT students Bangalore
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
