javascript - 使用 typeORM Select Query Builder 时如何格式化日期？

Question

我@CreateDateColumn()在模型中使用。使用查询生成器选择时，如何格式化选择内容中的日期？

  @CreateDateColumn()
  createdAt: Date;

    const documentarys = await getManager()
      .getRepository(IncomingDocumentary)
      .createQueryBuilder('d')
      .leftJoinAndSelect('d.tireBrand', 't')
      .select([
        'd.code as code',
        'd.tireSize as tireSize',
        'd.applicableCarModel as applicableCarModel',
        'd.amount as amount',
        'd.price as price',
        'd.createdAt as createTime',
        't.name as tireBrandName',
      ])
      .getRawMany();

标签： javascripttypeorm

Answer 1

使用 javascript 选择它后，您可以更轻松地对其进行格式化，但如果您真的想在选择查询中对其进行格式化，您应该使用您的数据库功能。例如，如果你有基于 sql 的数据库，你可以像这样格式化它：

const documentarys = await getManager()
  .getRepository(IncomingDocumentary)
  .createQueryBuilder('d')
  .leftJoinAndSelect('d.tireBrand', 't')
  .select([
    'd.code as code',
    'd.tireSize as tireSize',
    'd.applicableCarModel as applicableCarModel',
    'd.amount as amount',
    'd.price as price',
    'TO_CHAR(d.createdAt::DATE, 'dd/mm/yyyy')as createTime',
    't.name as tireBrandName',
  ])
  .getRawMany();