WinXP Client, Win2003 Server, MaxDB 7.6.00.34, SQLStudio 7.6.00.27(123692) Hello all ,
I am trying to write a code that calculates the age of an item but could not create the expected results. I tried producing some of the key values by running the following codes in the SQL Studio: SELECT DATE(2006-01-01) DAT1 , YEAR(DATE(2006-01-01)) YR1 , DAYOFMONTH(DATE(2006-01-01)) VAL1 , DAYOFYEAR(DATE(2006-01-01)) VAL2 FROM DUAL I got the following results: Dat1 Yr1 Val1 Val2 0006-06-27 6 27 178 I am new in MaxDB and I am not sure whether I'm using these functions in the proper way. Regards to all Raffy Segador __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
