File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
I am not getting a sum for report in java
Joined: Jun 18, 2004
Jun 18, 2004 10:31:00
I am writing a query in access which is running in access but when i run that in
it returns null value.
I also have a problem that how can i implement between clause with date.
Another one is that when i ask for date it is in it is in yyyy-mm-dd format i set date in dd-mm-yy format and short. but when i call it it shows first year than month and than day
author & internet detective
Joined: May 26, 2003
Jun 18, 2004 16:43:00
Welcome to Javaranch!
I strongly advise using a prepared statement for this query. Among other things, it allows the driver to handle date format issues.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: I am not getting a sum for report in java
how to change the date,Time format after accessing it from the database
How to convert String to Date
Formatting Date with Microsoft Access
conversion of date
Reading date from Excel Spreadsheet
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015