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 62 posted 8 years ago by jsturtevant
intfield has this format: YYYYMMDD
0 300 posted 8 years ago by wnasich
Select rows that are 3 months ahead or 3 months behind from the current date.
0 56 posted 8 years ago by jafar
1 75 posted 9 years ago by g8rpal
These statements convert a date/time field into just a date or a time field
2 88 posted 10 years ago by highlyevolved
1 61 posted 11 years ago by rtipton
An easy way to handle null dates. If date = 0000-00-00 then null, else use date
0 88 posted 12 years ago by Abe
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 201 posted 13 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 51 posted 13 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 60 posted 13 years ago by assbach
1 71 posted 13 years ago by olive
0 87 posted 13 years ago by olive
« Prev 1 Next »