Tags → Date Function Sql

Insert Date into Access Database

When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format. When working with a date in Access always use the # delimiters in your SQL statement.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Windows
• Licenses
  • Freeware

Returning Month of Date in an SQL Table

This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a ''SELECT'' sql statement

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Linux
• Licenses
  • Freeware

Using GetDate Function in an SQL Statement

This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Linux
• Licenses
  • Freeware