0

Converting the format of datebox filed inorder to fire a query

asked 2010-02-08 01:23:23 +0800

cros gravatar image cros
153

Hi,

I have a datebox where the value displayed in txtbox is for e.g "Feb 8, 2010"
When i retrieve the value using datebox.value , it is "Mon Feb 08 00:00:00 IST 2010"

Value stored in Db for datebox is in valueformat as "2010-02-08"
Now i want to fire a query for searching a parameter based on this datebox value.

How can compare the datebox value (Mon Feb 08 00:00:00 IST 2010) with DB value (2010-02-08)

DO I need to change the format.If so, how?

Please help me

Thanx in advance !!!

delete flag offensive retag edit

1 Reply

Sort by ยป oldest newest

answered 2010-02-09 18:56:58 +0800

PeterKuo gravatar image PeterKuo
481 2

updated 2010-02-09 18:57:12 +0800

datebox.getValue() returns java.util.Date

It's a general programming skill about java programming with db date format.

It should be easy to find solution by google (java date database).

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow

RSS

Stats

Asked: 2010-02-08 01:23:23 +0800

Seen: 289 times

Last updated: Feb 09 '10

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More