datetime – 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

Convert .NET Ticks to SQL Server DateTime

I don’t really know SQL Server, but today a colleague of mine had the same problem and I think I’ve found a solution like this: CAST(([ticks] – 599266080000000000) / 10000000 / 24 / 60 / 60 AS datetime) where 599266080000000000 is the ticks value for 01/01/1900 00:00:00.

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

Specifying date format when converting with pandas.to_datetime

You can use the parse_dates option from read_csv to do the conversion directly while reading you data. The trick here is to use dayfirst=True to indicate your dates start with the day and not with the month. See here for more information: http://pandas.pydata.org/pandas-docs/dev/generated/pandas.io.parsers.read_csv.html When your dates have to be the index: >>> import pandas as … Read more

Set timezone in PHP and MySQL

In PHP: <?php define(‘TIMEZONE’, ‘Europe/Paris’); date_default_timezone_set(TIMEZONE); For MySQL: <?php $now = new DateTime(); $mins = $now->getOffset() / 60; $sgn = ($mins < 0 ? -1 : 1); $mins = abs($mins); $hrs = floor($mins / 60); $mins -= $hrs * 60; $offset = sprintf(‘%+d:%02d’, $hrs*$sgn, $mins); //Your DB Connection – sample $db = new PDO(‘mysql:host=localhost;dbname=test’, ‘dbuser’, … Read more

Convert date from excel in number format to date format python [duplicate]

from datetime import datetime excel_date = 42139 dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + excel_date – 2) tt = dt.timetuple() print(dt) print(tt) As mentioned by J.F. Sebastian, this answer only works for any date after 1900/03/01 EDIT: (in answer to @R.K) If your excel_date is a float number, use this code: from datetime import datetime def … Read more

How to initialize a DateTime field?

mySmallVuln.Published = new DateTime(1998,04,30); Or perhaps like this var date = DateTime.MinValue; if (DateTime.TryParse(“1998/04/30”, out date)) { //Sucess… mySmallVuln.Published = date; }

Parse Date String to Some Java Object

Using Joda-Time, take a look at DateTimeFormat; it allows parsing both kind of date strings that you mention (and almost any other arbitrary formats). If your needs are even more complex, try DateTimeFormatterBuilder. To parse #1: DateTimeFormatter f = DateTimeFormat.forPattern(“yyyy-MM-dd HH:mm:ss”); DateTime dateTime = f.parseDateTime(“2012-01-10 23:13:26”); Edit: actually LocalDateTime is a more appropriate type for … Read more

Converting UTC dates to other timezones

It turns out the code was almost correct, what I didn’t take into account was that when parsing the String to get a Date object initially, it uses default system TimeZone, so the source date was not in UTC as I expected. The trick was to set the timezone when parsing the date to UTC … 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)))

+ More