Astera Data Stack
CtrlK
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • Astera 9.0 - Release Notes
  • Setting Up
    • System Requirements
    • Product Architecture
    • Installing Client and Server Applications
    • Connecting to a Astera Server using Lean Client
    • How to Connect to a Different Astera Server from the Lean Client
    • How to Set up a Server Certificate (.pfx) File in a New Environment
    • How to Build a Cluster Database and Create a Repository
    • How to Login from Lean Client
    • Licensing Model in Astera 9
    • User Roles and Access Control
    • Offline Activation of Astera Data Stack
  • Dataflows
    • Sources
    • Transformations
    • Destinations
    • Data Logging and Profiling
    • Database Write Strategies
    • Text Processors
    • Visualizations
  • Workflows
    • What are Workflows?
    • Creating Workflows in Astera
    • Decision Task
    • EDI Acknowledgment Task
    • File System Task
    • File Transfer Task
    • OR Task
    • Run Dataflow Task
    • Run Program Task
    • Run SQL File Task
    • Run SQL Script Task
    • Run Workflow Task
    • Send Mail Task
    • Workflows with a Dynamic Destination Path
    • Customizing Workflows With Parameters
    • GPG-Integrated File Decryption in Astera
  • Subflows
    • Using Subflows in Astera
  • DATA MODEL
    • Creating a Data Warehousing Project
    • Data Models
    • Dimensional Modelling
    • Documentation
    • Deployment and Usage
  • Functions
    • Introducing Function Transformations
    • Custom Functions
    • Logical
    • Conversion
    • Math
    • Financial
    • String
    • Date Time
    • Files
    • Date Time With Offset
      • ToDateTimeOffsetFromDateTime (dateTime String)
      • ToUtc (DateTimeWithOffset)
      • ToDateTimeOffsetFromDateTime
      • ToDateTimeOffset (String dateTimeOffsetStr)
      • ToDateTimeFromDateTimeOffset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
  • Report Model
    • User Guide
    • Report Model Interface
    • Use Cases
    • Auto Generate Layout (Beta)
    • Exporting Options
    • Miscellaneous
  • API Flows
    • API Consumption
  • Project Management
    • Project Management
    • Job Scheduling
  • Use Cases
    • End-to-End Use Cases
  • Connectors
    • Setting Up IBM DB2/iSeries Connectivity in Astera
    • Connecting to SAP HANA Database
    • Connecting to MariaDB Database
    • Connecting to Salesforce Database
    • Connecting to Salesforce - Legacy Database
    • Connecting to Vertica Database
    • Connecting to Snowflake Database
    • Connecting to Amazon Redshift Database
    • Connecting to Amazon Aurora Database
    • Connecting to Google Cloud SQL in Astera
    • Connecting to MySQL Database
    • Connecting to PostgreSQL in Astera
    • Connecting to Netezza Database
    • Connecting to Oracle Database
    • Connecting to Microsoft Azure Databases
    • Connecting to Amazon RDS Databases
  • Miscellaneous
    • Using Dynamic Layout Template Mapping in Astera
    • Synonym Dictionary File
    • SmartMatch Feature
    • Role Based Access Control in Astera
    • Updating Your License in Astera
    • Using Output Variables in Astera
    • Connection Vault
    • Safe Mode
    • Using the Data Source Browser in Astera
    • Pushdown Mode
    • Cloud Deployment
    • Context Information
  • Best Practices
    • Overview of Cardinality in Data Modeling
    • Cardinality Errors FAQs
    • Astera Best Practices - Dataflows
Powered by GitBook
On this page
  1. Functions

Date Time With Offset

ToDateTimeOffsetFromDateTime (dateTime String)ToUtc (DateTimeWithOffset)ToDateTimeOffsetFromDateTimeToDateTimeOffset (String dateTimeOffsetStr)ToDateTimeFromDateTimeOffset
PreviousWriteTextToFile (String filePath, String text)NextToDateTimeOffsetFromDateTime (dateTime String)

© Copyright 2025, Astera Software