LogoLogo
Go to Syntho.AI
English
English
  • Welcome to Syntho
  • Overview
    • Get started
      • Syntho bootcamp
        • 1. What is Syntho?
        • 2. Introduction data anonymization
        • 3. Connectors & workspace creation
        • 4. PII scan
        • 5. Generators
          • Mockers
          • Maskers
          • AI synthesize
          • Calculated columns
          • Free text de-identification
        • 6. Referential integrity & foreign keys
        • 7. Workspace synchronization & validation
        • 8. Workspace & user management
        • 9. Large workloads​
        • 10. AI synthesis: Data pre-processing when using
      • Prerequisites
      • Sample datasets
      • Introduction to data generators
      • AI-generated synthetic data
    • Frequently asked questions
  • Setup Workspaces
    • View workspaces
    • Create a workspace
      • Connect to a database
        • PostgreSQL
        • MySQL / MariaDB
        • Oracle
        • Microsoft SQL Server
        • DB2
        • Databricks
          • Importing Data into Databricks
        • Hive
        • SAP Sybase
        • Azure Data Lake Storage (ADLS)
        • Amazon Simple Storage Service (S3)
      • Workspace modes
    • Edit a workspace
    • Duplicate a workspace
    • Transfer workspace ownership
    • Share a workspace
    • Delete a workspace
    • Workspace default settings
  • Configure a Data Generation Job
    • Configure table settings
    • Configure column settings
      • AI synthesize
        • Sequence model
          • Prepare your sequence data
        • QA report
        • Additional privacy controls
        • Cross-table relationships limitations
      • Mock
        • Text
          • Supported languages
        • Numeric (integer)
        • Numeric (decimal)
        • Datetime
        • Other
      • Mask
        • Text
        • Numeric (integer)
        • Numeric (decimal)
        • Datetime
        • UUID
      • Duplicate
      • Exclude
      • Consistent mapping
      • Calculated columns
      • Key generators
        • Differences between key generators
      • JSON de-identification
    • Manage personally identifiable information (PII)
      • Privacy dashboard
      • Discover and de-identify PII columns
        • Identify PII columns manually
        • Automatic PII discovery with PII scanner
      • Remove columns from PII list
      • Automatic PII discovery and de-identification in free text columns
      • Supported PII & PHI entities
    • Manage foreign keys
      • Foreign key inheritance
      • Add virtual foreign keys
        • Add virtual foreign keys
        • Use foreign key scanner
        • Import foreign keys via JSON
        • Export foreign keys via JSON
      • Delete foreign keys
    • Validate and synchronize workspace
    • View and adjust generation settings
  • Deploy Syntho
    • Introduction
      • Syntho architecture
      • Requirements
        • Requirements for Docker deployments
        • Requirements for Kubernetes deployments
      • Access Docker images
        • Online
        • Offline
    • Deploy Syntho using Docker
      • Preparations
      • Deploy using Docker Compose
      • Run the application
      • Manually saving logs
      • Updating the application
      • Backup
    • Deploy Syntho using Kubernetes
      • Preparations
      • Deploy Ray using Helm
        • Upgrading Ray CRDs
        • Troubleshooting
      • Deploy Syntho using Helm
      • Validate the deployment
      • Troubleshooting
      • Saving logs
      • Upgrading the applications
      • Backup
    • Manage users and access
      • Single Sign-On (SSO) in Azure
      • Manage admin users
      • Manage non-admin users
    • Logs and monitoring
      • Does Syntho collect any data?
      • Temporary data storage by application
  • Syntho API
    • Syntho REST API
Powered by GitBook
On this page
  • Date
  • Date of birth
  • Date/Time
  • Date/Time series
  • Future date

Was this helpful?

  1. Configure a Data Generation Job
  2. Configure column settings
  3. Mock

Datetime

PreviousNumeric (decimal)NextOther

Last updated 2 months ago

Was this helpful?

Below is a list of available datetime mockers.

Date

Generates a random datetime object between two specified date objects, from year until days.

Parameters

  • Start date: The start date for the generation range (Format: %d/%m/%Y).

  • End date: The end date for the generation range (Format: %d/%m/%Y).

  • Consistent mapping: Date supports .

Example

If you configure:

03/11/2024 to 05/11/2024

The results will be:

2024-11-04,
2024-11-03,
2024-11-03,
...

Date of birth

Generates a date of birth which is a datetime object.

Parameters

Example

If you configure:

Locale: English (United States)

The results will be:

2025-03-17
2025-03-04
2025-03-13
2025-04-02
...

Date/Time

Generates a random datetime object between two specified datetime objects, from year until seconds.

Parameters

  • Start date: The start date for the generation range. (Format: %d/%m/%Y %H:%M:%S)

  • End date: The end date for the generation range.

Example

If you configure:

03/11/2024 06:00:00 to 05/11/2024 22:00:00

The results will be:

2024-11-05 08:52:41.340181,
2024-11-04 11:44:02.440943,
2024-11-03 21:43:52.323659,
...

Date/Time series

Generates a series of datetime values at regular intervals based on a specified time unit and step size.

Parameters

  • Start date: The starting date or datetime for the series.

  • Time unit: The unit of time for the step increment ("day", "week", "month", "year").

  • Number: The number of units to step forward per iteration.

Example

If you configure:

Start date: 03/11/2024 06:00:00
Time unit: Month
Number: 3

The results will be:

2024-11-03 06:00:00,
2025-02-03 06:00:00,
2025-05-03 06:00:00,
...

Future date

Generates a future datetime object, always after the current day.

Parameters

Example

If you configure:

Locale: English (United States)

The results will be:

2025-03-17
2025-03-04
2025-03-13
2025-04-02
...

Consistent mapping: Date supports .

Consistent mapping: Date/Time supports .

Consistent mapping: Future date supports .

consistent mapping
consistent mapping
consistent mapping
consistent mapping