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 888 posted 13 years ago by jsturtevant
intfield has this format: YYYYMMDD
0 3161 posted 13 years ago by wnasich
0 992 posted 13 years ago by danfsmith
Select rows that are 3 months ahead or 3 months behind from the current date.
0 862 posted 13 years ago by jafar
1 1074 posted 14 years ago by g8rpal
These statements convert a date/time field into just a date or a time field
2 1170 posted 15 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 2459 posted 18 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 1092 posted 18 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 951 posted 18 years ago by assbach
1 1882 posted 18 years ago by olive
0 1254 posted 18 years ago by olive
« Prev 1 Next »