Quizlet
or
Familiarize |
Learn |
Test |
|||
Play Scatter |
Play Space Race |
||||
Voice Scatter |
Voice Race |
||||
 Combine with other sets |
Login to add to Favorites |
| Print: Term List | Flashcards |
Editing not allowed |
| Export |
Deleting not allowed |
| With group: None | |
| HTML link to set: | Tiny link: |
 Share on Facebook |
 Share on MySpace |
| Term | Definition |
|---|---|
| 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 |
| EXTRACT() | 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 |
| Terms | 9 |
| Creator | jtwilliams00 |
| Created | March 30, 2009 |
| Groups | None |
| Subject | SQL |
| Access | Anyone |
| Edit | Creator Only |