timestamp – Make Me Engineer

How can I parse/format dates with LocalDateTime? (Java 8)

Parsing date and time To create a LocalDateTime object from a string you can use the static LocalDateTime.parse() method. It takes a string and a DateTimeFormatter as parameter. The DateTimeFormatter is used to specify the date/time pattern. String str = “1986-04-08 12:30”; DateTimeFormatter formatter = DateTimeFormatter.ofPattern(“yyyy-MM-dd HH:mm”); LocalDateTime dateTime = LocalDateTime.parse(str, formatter); Formatting date and … Read more

how to convert datetime to unix timestamp in c?

You could try a combination of strptime and mktime struct tm tm; time_t epoch; if ( strptime(timestamp, “%Y-%m-%d %H:%M:%S”, &tm) != NULL ) epoch = mktime(&tm); else // badness

How to compare sqlite TIMESTAMP values

The issue is with the way you’ve inserted data into your table: the +0200 syntax doesn’t match any of SQLite’s time formats: YYYY-MM-DD YYYY-MM-DD HH:MM YYYY-MM-DD HH:MM:SS YYYY-MM-DD HH:MM:SS.SSS YYYY-MM-DDTHH:MM YYYY-MM-DDTHH:MM:SS YYYY-MM-DDTHH:MM:SS.SSS HH:MM HH:MM:SS HH:MM:SS.SSS now DDDDDDDDDD Changing it to use the SS.SSS format works correctly: sqlite> CREATE TABLE Foo (created_at TIMESTAMP); sqlite> INSERT INTO … Read more

How to convert unix timestamp to date in Spark

Here it is using Scala DataFrame functions: from_unixtime and to_date // NOTE: divide by 1000 required if milliseconds // e.g. 1446846655609 -> 2015-11-06 21:50:55 -> 2015-11-06 mr.select(to_date(from_unixtime($”ts” / 1000)))

Spark DataFrame TimestampType – how to get Year, Month, Day values from field?

Since Spark 1.5 you can use a number of date processing functions: pyspark.sql.functions.year pyspark.sql.functions.month pyspark.sql.functions.dayofmonth pyspark.sql.functions.dayofweek pyspark.sql.functions.dayofyear pyspark.sql.functions.weekofyear import datetime from pyspark.sql.functions import year, month, dayofmonth elevDF = sc.parallelize([ (datetime.datetime(1984, 1, 1, 0, 0), 1, 638.55), (datetime.datetime(1984, 1, 1, 0, 0), 2, 638.55), (datetime.datetime(1984, 1, 1, 0, 0), 3, 638.55), (datetime.datetime(1984, 1, 1, 0, 0), … Read more

Python pandas convert datetime to timestamp effectively through dt accessor

I think you need convert first to numpy array by values and cast to int64 – output is in ns, so need divide by 10 ** 9: df[‘ts’] = df.datetime.values.astype(np.int64) // 10 ** 9 print (df) datetime ts 0 2016-01-01 00:00:01 1451606401 1 2016-01-01 01:00:01 1451610001 2 2016-01-01 02:00:01 1451613601 3 2016-01-01 03:00:01 1451617201 4 … Read more

Discard millisecond part from timestamp

A cast to timestamp(0) or timestamptz(0) rounds to full seconds: SELECT now()::timestamp(0); Fractions are not stored in table columns of this type. date_trunc() truncates (leaves seconds unchanged) – which is often what you really want: SELECT date_trunc(‘second’, now()::timestamp);

Creating a file name as a timestamp in a batch job

CP source.log %DATE:~-4%-%DATE:~4,2%-%DATE:~7,2%.log But it’s locale dependent. I’m not sure if %DATE% is localized, or depends on the format specified for the short date in Windows. Here is a locale-independent way to extract the current date from this answer, but it depends on WMIC and FOR /F: FOR /F %%A IN (‘WMIC OS GET LocalDateTime … Read more

Convert a Date (absolute time) to be sent/received across the network as Data in Swift?

You can send your Date converting it to Data (8-bytes floating point) and back to Date as follow: extension Numeric { var data: Data { var source = self return .init(bytes: &source, count: MemoryLayout<Self>.size) } init<D: DataProtocol>(_ data: D) { var value: Self = .zero let size = withUnsafeMutableBytes(of: &value, { data.copyBytes(to: $0)} ) assert(size … Read more

How to convert HH:mm:ss.SSS to milliseconds?

You can use SimpleDateFormat to do it. You just have to know 2 things. All dates are internally represented in UTC .getTime() returns the number of milliseconds since 1970-01-01 00:00:00 UTC. package se.wederbrand.milliseconds; import java.text.SimpleDateFormat; import java.util.Date; import java.util.TimeZone; public class Main { public static void main(String[] args) throws Exception { SimpleDateFormat sdf = new … Read more

+ More