CODEWITHSUNDEEP
javajakarta-eejdbc
Chaitanya Gudala
Chaitanya Gudala

Reputation: 305

Any chance of formatting Date object returned by resultset getDate() method

I want to skip the parsing of date and formatting it. Instead i directly want to fetch the date from database in custom format. Is this possible ?

Upvotes: 0

Views: 1820

Answers (3)

Binu
Binu

Reputation: 120

You need look into the functions provided by the database vendor.

For example, in Oracle we can use the following syntax in the SQL itself

TO_CHAR('date', 'format')

So go thru the documentation database you use.

Upvotes: 0

Augusto
Augusto

Reputation: 29877

Yes, change your SQL query to format the date. For example, if you use oracle, you need to use the function TO_CHAR(dateColumn, 'YYYY/MM/DD'), and that will return a String column with the date formatted as '2012/09/14'.

Upvotes: 1

swingNoobie
swingNoobie

Reputation: 151

You can set format in your query. (My example is run on sqlserver)

something like.. 

SELECT CONVERT (VARCHAR, GETDATE(), 103)

for more detail http://www.sqlusa.com/bestpractices2005/centurydateformat/

Upvotes: 0

Related Questions