UpDEV comments

Repositories
Issues
Comments

Results 3 comments of


                                            UpDEV

Converter campos created_at e updated_at de varchar para DateTime ou Timestamp no banco

Posso pegar essa atividade?

refactor: Change text fields in CREATED_AT and UPDATED_AT to TIMESTAMPZ type.

Esse MR, altera o tipo de dado em CREATED_AT e UPDATED_AT, em cada tabela, de varchar para TIMESTAMP WITH TIME ZONE. Alterados mapeamento dos modelos, fazendo remoção de ".toISOString()" na...

refactor: Change text fields in CREATED_AT and UPDATED_AT to TIMESTAMPZ type.

> ```sql > ALTER TABLE > "category_supplies" ALTER COLUMN "created_at" TYPE TIMESTAMP(3) WITH TIME ZONE USING > TO_TIMESTAMP("created_at", 'YYYY-MM-DD"T"HH24:MI:SS.FF3"Z"')::TIMESTAMP AT TIME ZONE 'UTC'; > ``` Migration executada com branch DEVELOP...