Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged date

« Prev 1 Next »

SQL Sql Date Difference

Can use second, Minute and many other from the url above

date

0 62 posted 8 years ago by jsturtevant

SQL Convert integer to date using SQL in iSeries DB2

intfield has this format: YYYYMMDD

date

0 300 posted 8 years ago by wnasich

SQL Find rows with last date of month

date

0 71 posted 8 years ago by danfsmith

SQL SQL SELECT 3 MONTHS +/-

Select rows that are 3 months ahead or 3 months behind from the current date.

date

0 56 posted 8 years ago by jafar

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

date

0 109 posted 9 years ago by ramirocalero

SQL only select date part from datetime

date

1 75 posted 9 years ago by g8rpal

SQL Convert Date/Time in SQL

These statements convert a date/time field into just a date or a time field

date

2 88 posted 10 years ago by highlyevolved

SQL Converting Dates in SQL Server

date

1 61 posted 11 years ago by rtipton

SQL Date 0000-00-00

An easy way to handle null dates. If date = 0000-00-00 then null, else use date

date

0 88 posted 12 years ago by Abe

SQL 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...

date

1 201 posted 13 years ago by jeffxl

SQL 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

date

2 51 posted 13 years ago by assbach

SQL now plus 20 years

useful if a "valid until" should have an exact ( in this case far future ) value.

date

0 60 posted 13 years ago by assbach

SQL Selection en fonction de la date

date

1 71 posted 13 years ago by olive

SQL Date au format XL

date

0 87 posted 13 years ago by olive

« Prev 1 Next »