Everyone's Recent SQL Snippets Tagged date

• All /
• JavaScript /
• HTML /
• PHP /
• CSS /
• Ruby /
• Objective C

1. 

   Sql Date Difference

   Can use second, Minute and many other from the url above
   SQL
   • date
   • sql
   9 views posted 8 years ago by jsturtevant
2. 

   Convert integer to date using SQL in iSeries DB2

   intfield has this format: YYYYMMDD
   SQL
   • date
   • sql
   23 views posted 8 years ago by wnasich
3. 

   Find rows with last date of month

   SQL
   • date
   • sql
   7 views posted 8 years ago by danfsmith
4. 

   SQL SELECT 3 MONTHS +/-

   Select rows that are 3 months ahead or 3 months behind from the current date.
   SQL
   • date
   • sql
   2 views posted 8 years ago by jafar
5. 

   Agreagar 0 a la izquierda de un numero o fecha. Padleft

   SQL
   • date
   • sql
   16 views posted 9 years ago by ramirocalero
6. 

   only select date part from datetime

   SQL
   • date
   • simple
   • sql
   saved by 3 people 10 views posted 9 years ago by g8rpal
7. 

   Convert Date/Time in SQL

   These statements convert a date/time field into just a date or a time field
   SQL
   • convert
   • date
   • sql
   saved by 6 people 6 views posted 10 years ago by highlyevolved
8. 

   Converting Dates in SQL Server

   SQL
   • date
   saved by 1 person 6 views posted 10 years ago by rtipton
9. 

   Date 0000-00-00

   An easy way to handle null dates. If date = 0000-00-00 then null, else use date
   SQL
   • date
   • sql
   2 views posted 12 years ago by Abe
10. 

    Created Date & Last Modified Date Triggers

    First, create two new fields in your table "Created", and "LastModified" as "datetime" fields, being sure to allow nulls. Then run this code as a query to create triggers that will update the appropriate field when a record is modified, or a record...
    SQL
    • date
    saved by 1 person 15 views posted 12 years ago by jeffxl
11. 

    SELECT older than x days

    2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days
    SQL
    • date
    • mysql
    saved by 4 people 3 views posted 12 years ago by assbach
12. 

    now plus 20 years

    useful if a "valid until" should have an exact ( in this case far future ) value.
    SQL
    • date
    • mysql
    3 views posted 13 years ago by assbach
13. 

    Selection en fonction de la date

    SQL
    • date
    saved by 1 person 5 views posted 13 years ago by olive
14. 

    Date au format XL

    SQL
    • date
    2 views posted 13 years ago by olive