Welcome To Snipplr
Everyone's Recent SQL Snippets Tagged date
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« Prev 1 Next »
Select rows that are 3 months ahead or 3 months behind from the current date.
0
862
posted 13 years ago by jafar
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
« Prev 1 Next »