Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

how to convert date into dd mon yyyy format

Posted on 2003-10-24
24
9,189 Views
Last Modified: 2007-12-19
hi all,
i have a problem in date format i am using date like below .
<%java.util.Date date = new java.util.Date();%>

i am inserting date into a table and its storing like this

insert into tablename (d_date) values (date)

and its inserting date like below

Sun Oct 19 09:05:45 GMT+03:00 2003

i want to fetch date in dd mon yyyy format.
with this format i want to make a select query.i struck with the format conversion.



how to do this.

waiting for expert solution.


0
Comment
Question by:saleemkhan
  • 12
  • 11
24 Comments
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614064
saleem,
You would be better off selecting the date from the database as is, then formatting it the way you want it using Java.  You could use the SimpleDateFormat class to accomplish this.

http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html
0
 

Author Comment

by:saleemkhan
ID: 9614087
Hi,
 zonebit,
  yes you are right i am fetching date from database only.
i just go throgh  the link u sent me.i couldnt work it out

can u help me
 convert
Sun Oct 19 09:05:45 GMT+03:00 2003
        to
dd mon yyyy

waiting for expert solution.
0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614151
I don't really program java but I think this should work.

import java.text.DateFormat;
import java.text.SimpleDateFormat;

// Select the date from the database and store it in a Date variable called yourDate //

String tPattern = "dd MMM yyyy";
SimpleDateFormat sdf = DateFormat.getDateInstance();
sdf.applyPattern(tPattern);
String formattedDate = sdf.format(yourDate);
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Comment

by:saleemkhan
ID: 9614261
i tried your comment,

i am getting error here

SimpleDateFormat sdf = DateFormat.getDateInstance();

type mismatch cannot convert from java.text.dateformat to java.text.simpledateformat

0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614277
We'll try this next:

String tPattern = "dd MMM yyyy";
SimpleDateFormat sdf = new SimpleDateFormat(tPattern);
sdf.applyPattern(tPattern);
String formattedDate = sdf.format(yourDate);
0
 

Author Comment

by:saleemkhan
ID: 9614339
i am getting error

Error 500: Server caught unhandled exception from servlet [JSP 1.2 Processor]: Cannot format given Object as a Date

String yourDate=null;
String tPattern = "dd MMM yyyy";
SimpleDateFormat sdf = new SimpleDateFormat(tPattern);
sdf.applyPattern(tPattern);
String formattedDate =" ";


          if (rs_register.next())             
              {
                    yourDate=rs_register.getString("register_date");
                  }  

 formattedDate=sdf.format(yourDate);
out.print(formattedDate);
0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614341
saleem,

yourDate needs to be a Date object, not a String object.
0
 

Author Comment

by:saleemkhan
ID: 9614418
i tried like this,

Date yourdate=null;


i am getting the type date is ambiguous.
0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614431
Try:

java.util.Date yourdate = null;
0
 

Author Comment

by:saleemkhan
ID: 9614460


gettting error here

yourDate=rs_register.getString("register_date");

type mismatch cannot convert from java.lang.string to java.lang.date

0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614501
try:

yourDate = rs_register.getDate("register_date");
0
 

Author Comment

by:saleemkhan
ID: 9614521
i alreday tried

yourDate =rs_gegister.getDate("register_date")

the database column is varchar2  its not date type

so i have to use

yourDate= rs_register.getString("register_date");

0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614534
right...

yourDate = Date.valueOf(rs_register.getString("register_date"));
0
 

Author Comment

by:saleemkhan
ID: 9614573
java compile error

Date cannot be resolved

yourDate = Date.valueOf(rs_register.getString("register_date"));




0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614578
yourDate = java.util.Date.valueOf(rs_register.getString("register_date"));
0
 

Author Comment

by:saleemkhan
ID: 9614605


java compile

the method valueOf java.lang.String is undefined for the type

java.util.Date

0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614627
yourDate = new java.util.Date(rs_register.getString("register_date"));
0
 

Author Comment

by:saleemkhan
ID: 9614673
java compile

the constructor java.util.date(java.lang.String) is deprecated
0
 
LVL 4

Expert Comment

by:Zonebit
ID: 9614703
yourDate = DateFormat.getDateTimeInstance(DateFormat.FULL, DateFormat.FULL).parse(rs_register.getString("register_date"));
0
 

Author Comment

by:saleemkhan
ID: 9614731
in compile no erros

when i run jsp and print it i am getting like this

Error 500: Unparseable date: "Sun Oct 19 09:05:45 GMT+03:00 2003"
0
 
LVL 4

Accepted Solution

by:
Zonebit earned 125 total points
ID: 9614782
tParsePattern = "EEE MMM dd HH:mm:ss zzz yyyy"
SimpleDateFormat ssdf = new SimpleDateFormat(tParsePattern);
yourDate = ssdf.parse(rs_register.getString("register_date"));
0
 

Author Comment

by:saleemkhan
ID: 9614936
i just tried like this

<%
java.util.Date yourDate = null;
String tParsePattern=null;
tParsePattern = "EEE MMM dd HH:mm:ss zzz yyyy";
SimpleDateFormat ssdf = new SimpleDateFormat(tParsePattern);
yourDate = ssdf.parse("Sun Oct 19 09:05:45 GMT+03:00 2003");
out.print(yourDate);
%>

i am getting error

Error 500: Unparseable date: "Sun Oct 19 09:05:45 GMT+03:00 2003"

0
 
LVL 2

Expert Comment

by:wellilein
ID: 9615713
According to the SDK JavaDoc, java.util.Date has the following methods:
getYear(), getMonth(), getDay()
You might try this:
java.util.Date date = new java.util.Date();
String s = date.getDay() + " " + date.getMonth() + " " + date.getYear();

But all these methods are deprecated. You should have a look at java.util.Calendar, which would be
java.util.Calendar cal = new java.util.Calendar();
String s = cal.get(Calendar.DAY_OF_MONTH) + " " + cal.get(Calendar.MONTH)+ " " +cal.get(Calendar.YEAR);
0
 

Author Comment

by:saleemkhan
ID: 9618958
i understand now where i am wrong.
the below code is not working why because in my server where i am executing code the regional setting month value is in arabic.
i executed the same code in a different server where date and time jones are english its working fine.
All the problem is in regional setting and not the jsp code.


tParsePattern = "EEE MMM dd HH:mm:ss zzz yyyy"
SimpleDateFormat ssdf = new SimpleDateFormat(tParsePattern);
yourDate = ssdf.parse(rs_register.getString("register_date"));
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This video teaches users how to migrate an existing Wordpress website to a new domain.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question