The format flag expects a golang time format.

For example

migrate create -ext sql -dir db/migrations -format 20060102150405 initial_blank

creates migration files

...\db\migrations\20241014135924_initial_blank.up.sql
...\db\migrations\20241014135924_initial_blank.down.sql

These are in UTC time.