AlterCreatedAtToTimestamp.ts

import { MigrationInterface, QueryRunner, TableColumn } from 'typeorm';

export default class AlterDateToDateTime1631573747885
  implements MigrationInterface
{
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.changeColumn(
      'leads',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp',
      }),
    );

    await queryRunner.changeColumn(
      'users',
      'createdAt',
      new TableColumn({
        name: 'users',
        type: 'timestamp',
      }),
    );

    await queryRunner.changeColumn(
      'teams',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp',
      }),
    );

    await queryRunner.changeColumn(
      'properties',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp',
      }),
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.changeColumn(
      'properties',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp with time zone',
      }),
    );

    await queryRunner.changeColumn(
      'teams',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp with time zone'
      }),
    );
    
    await queryRunner.changeColumn(
      'users',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp with time zone'
      }),
    );
    
    await queryRunner.changeColumn(
      'leads',
      'createdAt',
      new TableColumn({
        name: 'createdAt',
        type: 'timestamp with time zone'
      }),
    );
  }
}