electic

electic

DateTime Format to string?

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 format a datetime to a string. Can someone point me in the right direction?

Most Liked

sztosz

sztosz

You can do that

iex(1)> d = DateTime.utc_now
%DateTime{calendar: Calendar.ISO, day: 18, hour: 6, microsecond: {876000, 6},
 minute: 8, month: 9, second: 59, std_offset: 0, time_zone: "Etc/UTC",
 utc_offset: 0, year: 2016, zone_abbr: "UTC"}
iex(2)> DateTime.to_string(d)
"2016-09-18 06:08:59.876000Z" 
iex(3)> s = "#{d.year}/#{d.month}/#{d.day}"
"2016/9/18"
LostKobrakai

LostKobrakai

There‘s also a standalone strftime implemention:
https://github.com/plataformatec/nimble_strftime

Most things calendar did found it‘s way into elixir core in the last few versions, so I tend to suggest it (as well as timex) less and less.

kujua

kujua

Author of Erlang and Elixir for Imperative Programmers

Edited to clarify:

Another way is - using this Calendar library:

iex(1)> nbo = Calendar.DateTime.now! "Africa/Nairobi"
  %DateTime{calendar: Calendar.ISO, day: 23, hour: 12, microsecond: {149378, 6},
    minute: 31, month: 7, second: 54, std_offset: 0, time_zone: "Africa/Nairobi",
    utc_offset: 10800, year: 2016, zone_abbr: "EAT"}
iex(2)> nbo |> Calendar.DateTime.shift_zone!("Europe/Vienna")
            |> Calendar.DateTime.Format.iso8601 
  "2016-07-23T11:31:54.149378+02:00"

First we create a timezone for Nairobi. The library uses the names in this list, so we define Africa/Nairobi as timezone name.
On the line iex(2) is the command to get the current date and time formatted as universal date time. We convert this into the Europe/Vienna timezoneand then we format the date and time to ISO 8601. There are more than 20 formats to choose from and if this is not covering your case it is possible to define custom formats.

The library must be loaded, for example by adding a dependency to mix.exs ({:calendar, “~> 0.16.0”}) and then run iex -S mix.

From my book Erlang and Elixir for Imperative Programmers, page 120.

Where Next?

Popular in Questions Top

chokchit
** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2733ms. You can configure how long re...
New
_russellb
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
hariharasudhan94
lets say i have a sample like a = 20; b = 10; if (a > b) do {:ok, "a"} end if (a < b) do {:ok, b} end if (a == b) do {:ok, "equa...
New
Tee
can someone please explain to me how Enum.reduce works with maps
New
johnnyicon
Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
JDanielMartinez
Hi! May someone helps me, please! I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
hariharasudhan94
I would like to know what is the best IDE for elixir development?
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New

Other popular topics Top

malloryerik
Hi, this is for people who, like me, have had some friction using .html.heex templates in VSCode. The solution seems to be, in a hyphena...
New
TunkShif
This post is an instruction guide to help you setup your Neovim for Elixir development from scratch. It includes general information on h...
274 42158 114
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
AstonJ
Posting this to see if we can make things easier for people to get into Neovim. If you use Neovim and have a favourite distro please let ...
New
shahryarjb
Hello, I have map which I want to convert it to string like this: the map: %{last_name: "tavakkoli", name: "shahryar"} the string I ne...
New
stefanchrobot
What’s the safe way to decode a JSON string into a struct? I want to avoid calling String.to_atom. Jason.decode can give me a map with st...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
alice
Hey, Just curious what are the main benefits of Elixir compared to Clojure? When is Elixir more useful than Clojure and vice versa? Th...
New
saif
Hello everyone, Long time lurker first time poster here. I’ve recently begun working on Elixir full-time again! :raised_hands: It’s been...
New
komlanvi
Hi everyone, I was playing with phoenix liveView but I run into an issue. I have a form and want to validate each input text when the te...
New

We're in Beta

About us Mission Statement