![]() 4.7 What if I want to get the month as an integer out of a date?Ĭopyright 2001 Josh Berkus ( ).4.6 I need to display a DATE as text, or convert text into a DATE or INTERVAL.4.5 I'm porting an app from MS SQL Server, and I need to support the DATEDIFF and DATEADD functions so that my stored views will work.4.4.5 DATE/INTEGER cannot figure out the varying lengths of months and years.4.4.4 As with TIMESTAMP, you may NOT perform Addition, Multiplication, Division, or other operations with two DATES.4.4.3 Because the difference of two DATES is an INTEGER, this difference may be added, subtracted, divided, multiplied, or even modulo (%). ![]() 4.4.2 You may add or subtract an INTEGER to a DATE to produce another DATE.The difference between two DATES is always an INTEGER, representing the number of DAYS difference Many larger INTERVAL values, like the calendar values they reflect, are not constant in length when expressed in smaller INTERVAL values You may NOT (ever) perform Addition, Multiplication, or Division operations with two TIMESTAMPS ![]() Multiplication and division of INTERVALS is under development and discussion at this time You may add or subtract an INTERVAL to a TIMESTAMP to produce another TIMESTAMP The difference between two TIMESTAMPs is always an INTERVAL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |