How to get date only value from mysql date column?

[tsulatsitamim]

how to get "2021-10-08" instead of "2021-10-08T00:00:00.000Z" from mysql date column?
I use database query

[ruanitto]

You can use serialize method:

https://docs.adonisjs.com/guides/models/serializing-models#mutatingtransforming-values

@column.dateTime({
    autoCreate: true,
    serialize: (value: DateTime | null) => {
      return value ? value.toFormat('yyyy-MM-dd') : value
    },
  })
  public created_at: DateTime

[RomainLanz]

Hey @tsulatsitamim! 👋🏻

When defining your column, use the @column.date() decorator.

import { DateTime } from 'luxon'
import { column, BaseModel } from '@ioc:Adonis/Lucid/Orm'

class User extends BaseModel {
  @column.date()
  public dob: DateTime
}

📚 https://docs.adonisjs.com/reference/orm/decorators#columndate--columndatetime

[tsulatsitamim]

I use Database query here not Model

[thetutlage]

I have set column to regular string in model but still has time in response

Your original question mentioned you are using the Model. But anyways, you must share the proper code you have written to get proper help

[tsulatsitamim]

I'm sorry i've edit my question. the screenshot above show my query