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 884 posted 13 years ago by jsturtevant
intfield has this format: YYYYMMDD
0 3155 posted 13 years ago by wnasich
0 986 posted 13 years ago by danfsmith
Select rows that are 3 months ahead or 3 months behind from the current date.
0 855 posted 13 years ago by jafar
1 1068 posted 14 years ago by g8rpal
These statements convert a date/time field into just a date or a time field
2 1158 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 2455 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 1083 posted 18 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 948 posted 18 years ago by assbach
1 1878 posted 18 years ago by olive
0 1249 posted 18 years ago by olive
« Prev 1 Next »