search

nucleuscloud / neosync

Open source data anonymization and synthetic data orchestration for developers. Create high fidelity synthetic data and sync it across your environments.
https://www.neosync.dev
MIT License
2.67k stars 87 forks source link

[NEOS-1178] Improve Transformers for Timestamps #2148

Open nickzelei opened 1 month ago

nickzelei commented 1 month ago

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 commented 1 month ago

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 commented 1 month ago

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