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
504
posted 12 years ago by jafar
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
« Prev 1 Next »