Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged date



« Prev 1 Next »
  1. FAV

    Sql Date Difference

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

    Convert integer to date using SQL in iSeries DB2

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

    Find rows with last date of month

    SQL 7 views posted 8 years ago by danfsmith
  4. FAV

    SQL SELECT 3 MONTHS +/-

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

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

    SQL 16 views posted 9 years ago by ramirocalero
  6. FAV

    only select date part from datetime

    SQL saved by 3 people 10 views posted 9 years ago by g8rpal
  7. FAV

    Convert Date/Time in SQL

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

    Converting Dates in SQL Server

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

    Date 0000-00-00

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

    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 saved by 1 person 15 views posted 12 years ago by jeffxl
  11. FAV

    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 saved by 4 people 3 views posted 12 years ago by assbach
  12. FAV

    now plus 20 years

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

    Selection en fonction de la date

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

    Date au format XL

    SQL 2 views posted 13 years ago by olive
« Prev 1 Next »