Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

Author Topic: Mysql courses for BE IT students Bangalore  (Read 1149 times)

0 Members and 1 Guest are viewing this topic.

Offline Edwige

  • Newbie
  • *
  • Posts: 2
  • iTrader: +0/-0
    • View Profile
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 »

Divi WordPress Theme
Tags:
 

Related Topics

  Subject / Started by Replies Last post
8 Replies
3307 Views
Last post July 12, 2012, 12:29:05 PM
by madelinekim
1 Replies
1909 Views
Last post April 13, 2008, 07:15:49 PM
by John
1 Replies
3511 Views
Last post December 22, 2011, 05:52:05 PM
by wilsondavid
2 Replies
3316 Views
Last post November 25, 2009, 07:02:28 PM
by kvchosting
0 Replies
1264 Views
Last post November 10, 2011, 01:04:04 PM
by Edwige