QUESTIONS [message #486155] |
Tue, 14 December 2010 00:50 |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
Is there any function which will return/convert my TOTAL DAYS into YEAR, MONTH and DAYS?
Can I UPDATE my whole table without mensioning COLUMNS?
|
|
|
Re: QUESTIONS [message #486156 is a reply to message #486155] |
Tue, 14 December 2010 00:56 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
a) No, you'll have to write your own function (or search the Internet and use one you find)
b) I don't think so. You can SELECT or DELETE the whole table without using column names, but - for updating it - you have to say WHAT you are going to update (i.e. name the column(s)).
|
|
|