I am new with nestjs. How can I set columns that accepts Date format and dateTime format?
Not in both cases, the columns are two differents column, one accept Date and other dateTime.
You can see the docs here that explains the @Column decorator. In @Column there is an option called type -> here is where you specify which type of date you want to store for that specific column.
More on column types here.
For example (using PostgreSQL):
@Column({ type: 'date' })
date_only: string;
@Column({ type: 'timestamptz' }) // Recommended
date_time_with_timezone: Date;
@Column({ type: 'timestamp' }) // Not recommended
date_time_without_timezone: Date;
Note that date_only
is of type string. See this issue for more information.
Moreover, automatic dates for certain events are possible:
@CreateDateColumn()
decorator.@UpdateDateColumn()
decorator.@DeleteDateColumn()
decorator.@CreateDateColumn()
created_at: Date; // Creation date
@UpdateDateColumn()
updated_at: Date; // Last updated date
@DeleteDateColumn()
deleted_at: Date; // Deletion date
How about ?
@CreateDateColumn()
created_at: Date;
@UpdateDateColumn()
updated_at: Date;
EDIT
You can find more info here
To add more to this ticket as DateTime was not even mentioned:
/**
* Start DateTime
*/
@Column({
type: 'datetime',
default: () => 'NOW()',
})
@Index()
start: string;
/**
* End DateTime
*/
@Column({
type: 'datetime',
nullable: true,
})
@Index()
end: string;
This is for those not wanting or needing to use
@CreateDateColumn()
@UpdateDateColumn()
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With