Convert Online

SQLines SQL Converter

Overview
Command Line
Configuration File
Release Notes
Migration Ranking

SQLines Data

Overview
Command Line
Configuration File
Connection Strings
Data Validation
Release Notes

Migration to MariaDB

IBM DB2 to MariaDB
Informix to MariaDB
MySQL to MariaDB
Oracle to MariaDB
PostgreSQL to MariaDB
SQL Server to MariaDB
Sybase ASE to MariaDB
Sybase ASA to MariaDB

Migration to Oracle

IBM DB2 to Oracle
Informix to Oracle
PostgreSQL to Oracle
Sybase ASE to Oracle
Sybase ASA to Oracle
SQL Server to Oracle
Teradata to Oracle
MySQL to Oracle
MariaDB to Oracle

Oracle PL/SQL to Java
COBOL to Oracle PL/SQL

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
MySQL to SQL Server
Netezza to SQL Server
Oracle to SQL Server
PostgreSQL to SQL Server
Redshift to SQL Server
Sybase ASE to SQL Server
Sybase ASA to SQL Server
Sybase ADS to SQL Server

SQL Server to Synapse

Migration to MySQL

IBM DB2 to MySQL
Informix to MySQL
Oracle to MySQL
SQL Server to MySQL
Sybase ASE to MySQL
Sybase ASA to MySQL
PostgreSQL to MySQL

RPG to MySQL

Migration to PostgreSQL

IBM DB2 to PostgreSQL
Informix to PostgreSQL
MySQL to PostgreSQL
Oracle to PostgreSQL
SQL Server to PostgreSQL
Sybase ASE to PostgreSQL
Sybase ASA to PostgreSQL

Migration to IBM DB2

Oracle to IBM DB2
SQL Server to IBM DB2

Migration to Redshift

Hadoop to Redshift
Netezza to Redshift
Oracle to Redshift
SQL Server to Redshift
Teradata to Redshift

Migration to Databricks

SQL Server to Databricks

Migration to Snowflake

IBM DB2 to Snowflake
Hive to Snowflake
Oracle to Snowflake
SQL Server to Snowflake
Spark to Snowflake
Teradata to Snowflake

Migration to Spark

Oracle to Spark
Redshift to Spark
SQL Server to Spark
Teradata to Spark

Migration to Presto/Trino

Hive to Trino
Oracle to Trino
Redshift to Trino
SQL Server to Trino
Teradata to Trino

Migration to Netezza

Oracle to Netezza

Migration to Greenplum

IBM DB2 to Greenplum
Oracle to Greenplum

Migration to SingleStore

MySQL to SingleStore
SQL Server to SingleStore

Application Conversion

Java
C# .NET
PowerBuilder
COBOL

Database Reference

Oracle
SQL Server
IBM DB2
MariaDB
MySQL
PostgreSQL
Sybase
Sybase ASA
Informix
Teradata


CHAR Function for Datetime - IBM DB2 to SQL Server Migration

In DB2, you can use the CHAR function to convert a datetime value to string using the specified format, for example:

DB2: 

  CHAR(CURRENT_DATE, ISO)
  -- 2017-08-22

In SQL Server, you can use the CONVERT function with the specified style:

SQL Server: 

  CONVERT(VARCHAR, CONVERT(DATE, GETDATE()), 120)
  -- 2017-08-22

Mapping DB2 CHAR Formats to SQL Server CONVERT Styles

To convert DB2 CHAR function with specified datetime format you have to map the format to the corresponding style values of CONVERT function in SQL Server:

DB2 CHAR Format SQL Server CONVERT Style Format Example
1 ISO ISO Standard 120 YYYY-MM-DD 2017-08-22
2 USA United States 101 MM/DD/YYYY 08/22/2017
3 EUR Europe 104 DD.MM.YYYY 22.08.2017
4 JIS Japan 120 YYYY-MM-DD 2017-08-22

Examples:

DB2 SQL Server
1 CHAR(CURRENT_DATE, ISO) Convert to YYYY-MM-DD CONVERT(VARCHAR, CONVERT(DATE, GETDATE()), 120)
2 CHAR(CURRENT_DATE, USA) Convert to MM/DD/YYYY CONVERT(VARCHAR, CONVERT(DATE, GETDATE()), 101)
3 CHAR(CURRENT_DATE, EUR) Convert DD.MM.YYYY CONVERT(VARCHAR, CONVERT(DATE, GETDATE()), 104)
4 CHAR(CURRENT_DATE, JIS) Convert to YYYY-MM-DD CONVERT(VARCHAR, CONVERT(DATE, GETDATE()), 120)

Database and SQL Migration Tools

About SQLines

SQLines offers services and open source tools to help you migrate databases and applications. For more information, please contact us at support@sqlines.com.