| 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)).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
