Hi
With MySQL, I can actually manipulate the date using the built-in function
like:
SELECT DATE_ADD('2010-12-31 23:59:59', INTERVAL 1 DAY)
May I know if there is similar function in Derby? How do we manipulate the
date in Deby?
--
Hez
On 02/05/2011 20:53, Kristian Waagan wrote:
Hi John,
Looks to me like you are trying to access, or more specifically boot,
the database with the embedded driver. This won't work since the network
server has already booted the database [1].
The only change required should be to add the host name
hezjing hezj...@gmail.com writes:
Hi
With MySQL, I can actually manipulate the date using the built-in
function like:
SELECT DATE_ADD('2010-12-31 23:59:59', INTERVAL 1 DAY)
May I know if there is similar function in Derby? How do we manipulate
the date in Deby?
Derby supports the JDBC
Derby supports the JDBC escape function TIMESTAMPADD, documented here:
http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
Example:
ij values {fn timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31
23:59:59'))};
Are there any plans to make this function available in a more regular
On 02/05/2011 20:53, Kristian Waagan wrote:
Hi John,
Looks to me like you are trying to access, or more specifically boot,
the database with the embedded driver. This won't work since the network
server has already booted the database [1].
The only change required should be to add the host name
Lukas Eder lukas.e...@gmail.com writes:
Derby supports the JDBC escape function TIMESTAMPADD, documented here:
http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
Example:
ij values {fn timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31
23:59:59'))};
Are there any plans to make
On 5/3/11 4:52 AM, Lukas Eder wrote:
Derby supports the JDBC escape function TIMESTAMPADD, documented here:
http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
Example:
ij values {fn timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31 23:59:59'))};
Are there any plans to make this
Hi Rick and Knut,
Hi Lukas,
I don't see an existing JIRA for this issue. Feel free to log one.
Thanks,
-Rick
Done:
https://issues.apache.org/jira/browse/DERBY-5214
In the webapp:
server = new NetworkServerControl();
server.start(null);
Perhaps your webapp is trying to run these lines multiple times?
It can be very tricky to ensure that your webapp starts the
Network Server once and only once. You may be starting it
a second time, and the second instance