Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Java Essentials >> New To Java

how to convert perl script into exe file?

Hello Sir, I am working on jsp , fetching the datetime(08/21/2006 10:00:00PM) datatype value from MS SQL server database and need to displaying it in the following format Monday 16th, 2006 10:00:00PM in my webpage Anybody knows how to do this format? regards

[299 byte] By [Annamalaii1a] at [2007-10-3 3:16:33]

«« need sample prgms for JTAPI
»» Unable to get timer handles for containerId: jboss.j2ee:jndiName=

# 1

sorry the title is the above one

Annamalaii1a at 2007-7-14 21:07:59 >

top of Java-index,Java Essentials,New To Java...

# 2

Using the class SimpleDateFormat, I'd guess.

JoachimSauera at 2007-7-14 21:07:59 >

# 3

Do you have the sample code to do this format eactly what i mentioned ?

Annamalaii1a at 2007-7-14 21:07:59 >

# 4

No, Read the [url=http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html]API for SimpleDateFormat[/url] and understand it. Then apply that knowledge. There are even examples and you should really learn to read documentation, otherwise you'll allways depend on others to do your work ...

JoachimSauera at 2007-7-14 21:07:59 >

# 5

Boss,

i tried my level best.

See the problem is , while fetch the datetime data from MS sqlserver and display into jsp as like 2006-08-16 10:11:23.0

i am using result.getString(colno) to get the datetime value. but it returns the above, i wanted to convert and display as Wed Aug 16, 2006 10:45:32AM

i failed even after tried the SimpleDateFormat.

plz help me

Annamalaii1a at 2007-7-14 21:07:59 >

# 6

Get your field value from gthe result set into the appropriate type instead of String... then try the solution suggested above.

Franck_Lefevrea at 2007-7-14 21:07:59 >

# 7

I'm not your boss or even a boss.Don't use result.getString(colno), but rather result.getDate(colno). This way you'll have an object of type Date in your hands. Then try again with the SimpleDateFormat.

JoachimSauera at 2007-7-14 21:07:59 >

# 8

Excellent! Your suggestion worked out! You are my boss, since you only given me the solution.Thanks

Annamalaii1a at 2007-7-14 21:07:59 >

# 9

it would be so great if our code is able to display the time as well. but it doesn't not display the time !!!!

here is the code what i tried:

java.text.SimpleDateFormat fmt =

new java.text.SimpleDateFormat("EEE, MMM d, ''yy");

output:

Wed, Aug 16, '06

Annamalaii1a at 2007-7-14 21:07:59 >

# 10

[url=www.brucespringsteen.net/]The Boss[/url][url= http://www.imdb.com/gallery/mptv/1243/Mptv/1243/4599_0013.jpg?path=pgallery&path_key=Booke,%20Sorrell]The Boss[/url]

filestreama at 2007-7-14 21:07:59 >

# 11

Obviously, because you didn't tell it to display the time ... read the API for SimpleDateFormat again and check wether there is any way to include the time ...

JoachimSauera at 2007-7-14 21:07:59 >

# 12

when i tried to modify the above code as java.text.SimpleDateFormat fmt =new java.text.SimpleDateFormat("EEE, MMM d, yyyy hh:mm:ss");it always displays the date correctly Wed, Aug 16, 2006 12:00:00 but time always 12:00:00 !!!!!!!

Annamalaii1a at 2007-7-14 21:07:59 >

# 13

Oops ... I've forgotten that JDBC has it's own idea of the Date datatype. You should have used getTimestamp() instead of getDate().

JoachimSauera at 2007-7-14 21:07:59 >

# 14

wow.. you are amazing! I am much obliged to You !! Regardsvenki

Annamalaii1a at 2007-7-14 21:07:59 >

# 15

Have you read the JavaDoc ? I found it pretty clear about the time patterns...

Franck_Lefevrea at 2007-7-21 10:08:10 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

how to convert perl script into exe file?

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified