How to remove milliseconds from timestamp in javascript

Questions : How to remove milliseconds from a timestamp

2022-09-22T08:19:58+00:00 2022-09-22T08:19:58+00:00

850

I was asked this question :

Given a timestamp as a long value, write a anycodings_timestamp utility function in Java to drop the anycodings_timestamp milliseconds. For example, given an input of anycodings_timestamp 1274883865399 (actual time: anycodings_timestamp 20100526T14:24:25.399Z), the function would anycodings_timestamp return 1274883865000 (actual time: anycodings_timestamp 2010-05-26T14:24:25.000Z)

I did this :

import java.text.*; import java.util.*; public class ClearMilliSeconds { public static void main(String[] args) { long yourmilliseconds = 1274883865399L; SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm"); Calendar c = Calendar.getInstance(); Date resultdate = new Date(yourmilliseconds); c.set(Calendar.MILLISECOND, 0); resultdate.setTime(c.getTimeInMillis()); System.out.println(sdf.format(resultdate)); } }

But it did not give me the right result

Total Answers 3

31

Answers 1 : of How to remove milliseconds from a timestamp

If I understand you correctly there is anycodings_timestamp no need to use Date / Calendar...

long yourmilliseconds = 1274883865399L; long droppedMillis = 1000 * (yourmilliseconds/ 1000); System.out.println(droppedMillis);

1274883865000

Or... if you wish to have date anycodings_timestamp formatting...

Calendar c = Calendar.getInstance(); c.setTime(new Date(yourmilliseconds)); c.set(Calendar.MILLISECOND, 0); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm.ss.SSS'Z'"); sdf.setTimeZone(TimeZone.getTimeZone("GMT")); System.out.println(sdf.format(c.getTime()));

2010-05-26T14:24.25.000Z

0

2022-09-22T08:19:58+00:00 2022-09-22T08:19:58+00:00Answer Link

mRahman

5

Answers 2 : of How to remove milliseconds from a timestamp

Had same issue had my initial timestamp anycodings_timestamp stored in sq and did anycodings_timestamp sq.setTime(1000*(long)Math.floor(sq.getTime()/ anycodings_timestamp 1000)); that does the job. In my case sq anycodings_timestamp is a sql.Timestamp

0

2022-09-22T08:19:58+00:00 2022-09-22T08:19:58+00:00Answer Link

raja

1

Answers 3 : of How to remove milliseconds from a timestamp

Your code was buggy: You didn't apply anycodings_timestamp the yourmilliseconds to c(Calendar). The anycodings_timestamp fix, to stay within the boundaries of anycodings_timestamp your code:

import java.text.*; import java.util.*; public class ClearMilliSeconds { public static void main(String[] args) { long yourmilliseconds = 1274883865399L; Calendar c = Calendar.getInstance(); c.setTimeInMillis(yourmilliseconds); c.set(Calendar.MILLISECOND, 0); Date resultdate = new Date(c.getTimeInMillis()); SimpleDateFormat sdf = new SimpleDateFormat("MMM dd,yyyy HH:mm"); System.out.println(sdf.format(resultdate)); } }

0

2022-09-22T08:19:58+00:00 2022-09-22T08:19:58+00:00Answer Link

jidam

How can I remove milliseconds from timestamp in oracle insert query using TO_DATE

Questions : How can I remove milliseconds from timestamp in oracle insert query using TO_DATE

2022-09-22T08:19:59+00:00 2022-09-22T08:19:59+00:00

677

I have a value like this '2019-05-04 anycodings_timestamp 12:34:20' which I obtain from another anycodings_timestamp database using python code But when I run anycodings_timestamp the below query in oracle,

INSERT INTO sample_table(SCHEDULED_DATE) VALUES (TO_DATE('2019-05-04 12:34:20','YYYY-MM-DD HH24:MI:SS'));

I am getting an output like this,

'04-05-19 12:34:20.000000000 PM'

What I want is:

'2019-05-04 12:34:20'

Total Answers 1

25

Answers 1 : of How can I remove milliseconds from timestamp in oracle insert query using TO_DATE

What you are expecting and what you are anycodings_timestamp getting is the same value.

It is just the representation. anycodings_timestamp SCHEDULED_DATE is the timestamp data anycodings_timestamp type and it shows milliseconds as 000..

You can use TO_CHAR to see the value in anycodings_timestamp the format that you anycodings_timestamp want(to_char(SCHEDULED_DATE, 'YYYY-MM-DD anycodings_timestamp HH24:MI:SS')). and anyway you are adding anycodings_timestamp date into timestamp so your timestamp anycodings_timestamp will always have 000.. in the anycodings_timestamp millisecond.

0

2022-09-22T08:19:59+00:00 2022-09-22T08:19:59+00:00Answer Link

mRahman

How do I remove milliseconds from timeStamp?

How to remove seconds from time in javascript?

What is timestamps in Javascript?