<@UESADRKMY>, I wanted to store createdDate (with ...
# orm-help
s
@Ryan, I wanted to store createdDate (with specific timezone) in 
test
 table for column 
createdDate
 but in my case issue is graphql automatically convert into UTC, so, It store UTC date in DB Also I tried with custom resolver to modify UTC into company timezone but still it stores UTC value, because of the prisma I think
Copy code
let date = dayjs().tz(authenticated.companyTimezone).format('YYYY-MM-DD HH:mm:ss') (OUTPUT "2021-10-19T13:42:00+02:00")
const payload = {
      ...data,
      CreatedDate: date,
    }
    return prisma.Test.create({
      data: payload,
      ...select,
    })
So, again prisma convert into UTC because of 
+02.00
 in above date value.
r
@Suhani Shah 👋 Yes Prisma converts the dates to UTC before storing. This is to make sure that queries for dates is also done in the same format and you get similar results.
s
Yes, But I don't want to store date in UTC, I need dates in specific timezone, Is there any solution/opinion according to you ?
r
Unfortunately not, I would suggest adding a 👍 to this request so that we can look into this.
🙌 1