Solved

how to get yydddsssssmmmm format from Current Data base Timestamp in DB2

Posted on 2004-09-02
11
348 Views
Last Modified: 2008-01-09
Hi,

   My requirement is to generate unique sequence number with the following format

  i.e. yydddsssssmmmm

       yy = year
       ddd = julian date
       sssss = current seconds
       mmmm = milliseconds

I am able to do first 2 things. How about the rest.
I appreciate your ideas!!!

Thanks
0
Comment
Question by:mvkraju
[X]
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
11 Comments
 
LVL 37

Expert Comment

by:zzynx
ID: 11964461
what do you mean with "current seconds"? (and it can be 5 digits long????)
You don't mean the seconds part of the current time, do you?
0
 
LVL 35

Expert Comment

by:TimYates
ID: 11964516
and the same question for miliseconds ;-)
0
 
LVL 37

Expert Comment

by:zzynx
ID: 11964532
Guess you mean yydddssmmm.

Then you become the last part by

SimpleDateFormat fmt = new SimpleDateFormat("ssSSS");
String lastPart = fmt.format( new Date() );

0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 37

Expert Comment

by:zzynx
ID: 11964541
...assuming you DO mean the (milli)seconds part of the current time
;°)
0
 

Author Comment

by:mvkraju
ID: 11964575
i mean
sssss - Seconds past midnight (0 - 86399).
mmmm - milli seconds past the second

0
 
LVL 37

Accepted Solution

by:
zzynx earned 50 total points
ID: 11964645
>>sssss - Seconds past midnight (0 - 86399).
That's maths: sssss = hours * 3600 + minutes * 60 + seconds

>>mmmm - milli seconds past the second
Think you mean
      mmm - milli seconds past the second (0-999)

That's:
SimpleDateFormat fmt = new SimpleDateFormat("SSS");
String millis = fmt.format( new Date() );
0
 
LVL 37

Expert Comment

by:zzynx
ID: 11964683

Calendar cal = Calendar.getInstance();
int hours = cal.get(Calendar.HOUR_OF_DAY);
int minutes = cal.get(Calendar.MINUTE);
int seconds = cal.get(Calendar.SECOND);
0
 

Author Comment

by:mvkraju
ID: 11965688
This is fine, how do i get Calendar from java.sql.Timestamp?
Because after i got DB Current Timestamp, i have it in java.sql.Timestamp object.
0
 

Author Comment

by:mvkraju
ID: 11965734
I mean without loosing nanos precision.
We can use set(int year, int month, int date, int hour, int minute, int second)  method of Calendar.
But i loose nono second precision.
0
 
LVL 21

Expert Comment

by:MogalManic
ID: 11965877
Try the following
  TimeStamp t;
  ...Get the data from DB...
  Calendar dt=Calandar.getInstance();
  dt.setDate(t);

  SimpleDateFormat fmt = new SimpleDateFormat("ssSSS");
  String lastPart = fmt.format(dt.getTime());
  lastPart=lastPart+t.getNanos();
0
 
LVL 37

Expert Comment

by:zzynx
ID: 11970570
Thanks for accepting
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
configure dependency in POM for new database 3 48
Java: The Public Class Main 4 46
ejb entity bean example 2 39
ejb mdb examples 1 21
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

730 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