• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

Mysql courses for BE IT students Bangalore

Started by Edwige, November 10, 2011, 01:05:51 PM

Edwige

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