Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged date



« Prev 1 Next »
Can use second, Minute and many other from the url above
0 489 posted 12 years ago by jsturtevant
intfield has this format: YYYYMMDD
0 2538 posted 12 years ago by wnasich
0 587 posted 12 years ago by danfsmith
Select rows that are 3 months ahead or 3 months behind from the current date.
0 504 posted 12 years ago by jafar
1 640 posted 13 years ago by g8rpal
These statements convert a date/time field into just a date or a time field
2 730 posted 14 years ago by highlyevolved
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...
1 1846 posted 16 years ago by jeffxl
2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days
2 622 posted 17 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 531 posted 17 years ago by assbach
1 1167 posted 17 years ago by olive
0 752 posted 17 years ago by olive
« Prev 1 Next »