neosync icon indicating copy to clipboard operation
neosync copied to clipboard

[NEOS-1178] Improve Transformers for Timestamps

Open nickzelei opened this issue 1 year ago • 2 comments

Our transformers for timestamps aren't great right now, and/or they are quite limiting.

I have a timestamp with timezonea and all I see is this:

image.png

From SyncLinear.com | NEOS-1178

nickzelei avatar Jun 14 '24 01:06 nickzelei

This could be a good usecase of adding a new timestamp transformer that is really smart and is very typeaware.

It should handle ints, strings, time, timez, timestampz, timestamp.

nickzelei avatar Jun 14 '24 01:06 nickzelei

More info here of general timestamps:

  1. UTC
  2. Specific Timezone
  3. System Time
  4. Unix

Types of Time:

  1. Now() - current time for inserted record
  2. Random()
    1. Provide a range of times to generate time for Apr 2023 - May 2024

nickzelei avatar Jun 18 '24 17:06 nickzelei