gabriel137
How to convert unix to NaiveDateTime?
I receive data in timestamp format (unix), for example, “1466329342388” and I need to convert it to the DateTime format that would be the NaiveDateTime in the case to insert in my bank, I only see the conversion in reverse, but not in this way , someone to help me?
Marked As Solved
wojtekmach
Hex Core Team
You can do the following:
iex> 1466329342 |> DateTime.from_unix!() |> DateTime.to_naive()
~N[2016-06-19 09:42:22]
note, I removed the trailing 388, the milliseconds, as the function only accepts whole seconds, you’d need to manually add that back.
Out of curiosity, why do you need it as naive date time? Given unix time is essentially %DateTime{} in UTC timezone, I’d consider keeping that representation in your app.
1
Also Liked
benwilson512
Author of Craft GraphQL APIs in Elixir with Absinthe
This can be changed with an argument:
iex(1)> 1466329342388 |> DateTime.from_unix!(:millisecond) |> DateTime.to_naive()
~N[2016-06-19 09:42:22.388]
2
NobbZ
Of course, I just wanted to say that not everything that looks like a Unix timestamp is in UTC…
1
Popular in Questions
can someone please explain to me how Enum.reduce works with maps
New
I’m hoping you guys can give me some general advice and perhaps code examples if you’re feeling up to it.
I’m very interested in Elixir,...
New
Hi, I’m using Ubuntu 18.04 and after updating to OTP-24.0 yesterday i have this warning when I run “mix local.hex”:
14:57:30.512 [warn] ...
New
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service.
Currently when I de...
New
As many of you may have realized by now (sorry for all the posts here) I’ve been working on a db problem where I’m trying to aggregate a ...
New
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
Is there a way to get the call stack or stack trace at any point in the code? Not from exceptions, but an expression that returns how the...
New
Forgive me if this is obvious, but how does one delete a database record WITHOUT selecting it first? https://hexdocs.pm/ecto/Ecto.Repo.h...
New
Mix format works fine if run from the cmd. I’ve followed this to facilitate the implementation into VSC which involves downloading an ext...
New
I’ve been re-reading swift book again and noticed that multiline strings there don’t have a trailing line break, unlike in elixir
iex(2)...
New
Other popular topics
Here are few pieces of (common) Linux knowledge that we use for reasonably small one server apps. We use Ubuntu but this should work for ...
New
Hi there,
I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 record...
New
This post is a wiki (feel free to hit the edit button near the bottom right of this post to add your own changes!)
This post collects co...
New
I want to try my hand at web scraping. What tools/libraries do I need to use. I’m hoping to turn this into something professional so don’...
New
I am trying to figure out how Mix knows whether the environment is test, dev, or prod -- where is this set?
Thanks.
New
As a follow up to my earlier question:
I have the code compiling and running but not getting a successful login from the rest server. ...
New
This release brings a number of exciting features, including integration with the new Phoenix LiveDashboard and Phoenix LiveView. There h...
New
Hi,
I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
This post is an instruction guide to help you setup your Neovim for Elixir development from scratch. It includes general information on h...
New








