Hi,
all, i am trying to change the name of my table name present in my database....
i am using this query

ALTER TABLE USERS RENAME TO USERS1 this thing works very good...
the problem is i need to create my table name basing upon the current system time....
is this possible.... to have system current time as my table...

the query for that which i am trying is


Alter table USERS1 Rename to time('now','localtime'); query string is returning an exception saying that " there is an error at '(' "


So can any one help me sorting this


Thanks in advance....