stefanchrobot

stefanchrobot

Inverse of DateTime.truncate?

Is there an inverse of DateTime.truncate? I have a DB column with :utc_datetime_usec type and I’m putting data coming from external system that has only precision up to a second.

I’m doing %{datetime | microsecond: {0, 6}} but maybe there’s a better way?

Should this be handled by Ecto internally? Seems like it’s failing on purpose.

Most Liked

eksperimental

eksperimental

from the DateTime docs:

Developers should avoid creating the DateTime struct directly and instead rely on the functions provided by this module as well as the ones in third-party calendar libraries.

stefanchrobot

stefanchrobot

Here’s the helper that I came up with. Only covers the use case I need, doctests included:

@doc """
Ensures that the given `DateTime` has the specified precision.

    iex> ensure_precision(~U[2022-01-01 10:00:00Z], :microsecond)
    ~U[2022-01-01 10:00:00.000000Z]

    iex> datetime = ~U[2022-01-01 10:00:00.123Z]
    iex> DateTime.compare(datetime, ensure_precision(datetime, :microsecond))
    :eq
"""
def ensure_precision(%DateTime{microsecond: {_, 6}} = datetime, :microsecond) do
  datetime
end

def ensure_precision(%DateTime{microsecond: {value, _precision}} = datetime, :microsecond) do
  %{datetime | microsecond: {value, 6}}
end
josevalim

josevalim

Creator of Elixir

DateTime.add(datetime, value, :microsecond)

Edit: ignore me, this does not change the precision of the DateTime but perhaps it should.

stefanchrobot

stefanchrobot

Doesn’t seem to work for me on Elixir 1.10:

iex> DateTime.utc_now() |> DateTime.truncate(:second) |> DateTime.convert!(Calendar.ISO) |> Map.get(:microsecond)
{0, 0}
eksperimental

eksperimental

I was wrong there. I wasn’t able to find anything.
Sounds like a set of extend/2 functions which take the same arguments as truncate/2 could be helpful.

Where Next?

Popular in Questions Top

srinivasu
How to handle excepions in elixir? Suppose i have A, B, C ,D, E modules. and each module has get() function. A.get() method will call th...
New
yawaramin
In the Dialyzer docs ( http://erlang.org/doc/man/dialyzer.html#requesting-or-suppressing-warnings-in-source-files ), there is a way to tu...
New
fireproofsocks
I’m working on defining a simple Ecto schema for a table (in PostGres), but I don’t see where I can define a column as NOT NULL. Conside...
New
rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list....
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
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
electic
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
Codball
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
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers' Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
lucidguppy
I have a super simple question about elixir - how would I take a file like this foo bar baz and output a new file that enumerates th...
New

Other popular topics Top

Qqwy
Update: How to use the Blogs & Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3268 119930 1237
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
aalberti333
As the title describes, I’m trying to run Enum.map() over a list of key/value pairs, where the value is a map. My data looks like this: ...
New
polypush135
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
danschultzer
None of the current solutions worked well for me, so I went ahead and built a user management system from scratch. This project took far...
548 27727 240
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
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
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New
AstonJ
We’ve put together this wiki for Phoenix LiveView - please feel free to add any info you feel is worth including. What is Phoenix LiveV...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New

We're in Beta

About us Mission Statement