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 1455 posted 14 years ago by jsturtevant
intfield has this format: YYYYMMDD
0 4054 posted 14 years ago by wnasich
0 1752 posted 14 years ago by danfsmith
Select rows that are 3 months ahead or 3 months behind from the current date.
0 1379 posted 14 years ago by jafar
1 1865 posted 15 years ago by g8rpal
These statements convert a date/time field into just a date or a time field
2 2047 posted 16 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 3166 posted 19 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 1975 posted 19 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 1470 posted 19 years ago by assbach
1 2874 posted 19 years ago by olive
0 2973 posted 19 years ago by olive
« Prev 1 Next »