[Solved] Given this entity code snippet, what will be the database column type for createdAt? @Entity() export class Post { @PrimaryGeneratedColumn() id: number; @Column({ type: 'timestamp' }) createdAt:... | NestJS

NestJS - Database with TypeORM

Given this entity code snippet, what will be the database column type for createdAt?

@Entity()
export class Post {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({ type: 'timestamp' })
  createdAt: Date;
}

AA string column storing date as text

BA boolean column indicating creation status

CAn integer column storing Unix timestamp

DA timestamp column storing date and time

Step-by-Step Solution

Solution:

Step 1: Check the @Column decorator options
The type: 'timestamp' option specifies the database column type as timestamp.
Step 2: Understand how Date maps to database types
In TypeORM, a Date property with type 'timestamp' stores date and time values in the database.
Final Answer:
A timestamp column storing date and time -> Option D
Quick Check:
Timestamp column type [OK]

Quick Trick: Use type: 'timestamp' for date-time columns [OK]

Common Mistakes:

Master "Database with TypeORM" in NestJS

9 interactive learning modes - each teaches the same concept differently

More NestJS Quizzes

Given this entity code snippet, what will be the database column type for createdAt?