The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Java Answers Forum
Date Data Type Field

1 reply on 1 page. Most recent reply: Nov 5, 2003 12:38 PM by Jonathon Brozny

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 1 reply on 1 page
Dar

Posts: 9
Nickname: dar
Registered: Oct, 2003

Date Data Type Field Posted: Nov 5, 2003 12:08 PM
Reply to this message Reply
Advertisement
I have a column in my Oracle Database table called (closeDate) which is a Date data type. I need to run a query to get all records from this table where the closeDate column is empty, meaning no data has been entered.

I realize this forum is for Java, but the application I'm developing is Java based with an Oracle database.

Any suggestions on how I can query this closeDate column in my WHERE clause to return records where the closeDate column is empty would be appreciated.


Thanks,


Jonathon Brozny

Posts: 24
Nickname: jonathon
Registered: Oct, 2003

Re: Date Data Type Field Posted: Nov 5, 2003 12:38 PM
Reply to this message Reply
Is the column set up with a default value? if not then it should be null. Its been about 8 months since I have uses Oracle (I never had that much experience anyway) and I don't have it set up anymore to test it, but this should be what you need.

WHERE closeDate is null

Flat View: This topic has 1 reply on 1 page
Topic: Automatic Selection of Printer not working Previous Topic   Next Topic Topic: Synchronization in Java
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use