CONVERT For Time Function - SQL Server to PostgreSQL Migration

In SQL Server you can use CONVERT function to convert an expression (a string i.e.) to TIME data type. In PostgreSQL you can to use CAST or various type conversion functions.

SQL Server:

  -- Convert string to TIME
  SELECT CONVERT(TIME, '11:11'); 
  # 11:11:00.0000000

PostgreSQL:

  -- Convert string to TIME
  SELECT CAST( '11:11' AS TIME); 
  # 11:11:00

For more information, see SQL Server to PostgreSQL Migration

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to SingleStore

Migration to IBM DB2

Migration to Redshift

Migration to Snowflake

Migration to Apache Hive

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to EsgynDB

Application Conversion

Database Reference

CONVERT For Time Function - SQL Server to PostgreSQL Migration