feat: cast date field from datetime to date string format (#3673)

maximepvrt · web-flow · commit f1a2ca4a1c8e · 2026-01-16T10:41:04.000+01:00
diff --git a/src/runtime/internal/schema.ts b/src/runtime/internal/schema.ts
@@ -5,6 +5,7 @@ const propertyTypes = {
   number: 'INT',
   boolean: 'BOOLEAN',
   date: 'DATE',
+  datetime: 'DATETIME',
   enum: 'VARCHAR',
   object: 'TEXT',
 }
@@ -33,10 +34,14 @@ function getPropertyType(property: Draft07DefinitionProperty | Draft07Definition
   const propertyType = (property as Draft07DefinitionProperty).type
   let type = propertyTypes[propertyType as keyof typeof propertyTypes] || 'TEXT'
 
-  if ((property as Draft07DefinitionProperty).format === 'date-time') {
+  if ((property as Draft07DefinitionProperty).format === 'date') {
     type = 'DATE'
   }
 
+  if ((property as Draft07DefinitionProperty).format === 'date-time') {
+    type = 'DATETIME'
+  }
+
   if ((property as Draft07DefinitionPropertyAllOf).allOf) {
     type = 'TEXT'
   }
diff --git a/src/utils/schema/valibot.ts b/src/utils/schema/valibot.ts
@@ -6,7 +6,7 @@ export function toJSONSchema(schema: unknown, name: string): Draft07 {
   const definitions = valibotToJsonSchema(schema as any, {
     overrideSchema(context) {
       if (context.valibotSchema.type === 'date') {
-        return { type: 'string', format: 'date-time' }
+        return { type: 'string', format: 'date' }
       }
       if ((context.valibotSchema as unknown as { $content: Record<string, unknown> }).$content) {
         return {
diff --git a/src/utils/schema/zod3.ts b/src/utils/schema/zod3.ts
@@ -30,12 +30,13 @@ export const z = zod
 
 export function toJSONSchema(_schema: unknown, name: string): Draft07 {
   const schema = _schema as zod.ZodSchema
-  const jsonSchema = zodToJsonSchema(schema, { name, $refStrategy: 'none' }) as Draft07
+  const jsonSchema = zodToJsonSchema(schema, { name, $refStrategy: 'none', dateStrategy: 'format:date' }) as Draft07
   const jsonSchemaWithEditorMeta = zodToJsonSchema(
     schema,
     {
       name,
       $refStrategy: 'none',
+      dateStrategy: 'format:date',
       override: (_def) => {
         const def = _def as unknown as Record<string, unknown>
         if (def.editor) {
diff --git a/src/utils/schema/zod4.ts b/src/utils/schema/zod4.ts
@@ -14,7 +14,7 @@ export function toJSONSchema(
         const def = ctx.zodSchema._zod?.def as unknown as Record<string, unknown>
         if (def?.type === 'date') {
           ctx.jsonSchema.type = 'string'
-          ctx.jsonSchema.format = 'date-time'
+          ctx.jsonSchema.format = 'date'
         }
         if (def?.$content) {
           ctx.jsonSchema.$content = def.$content

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@ export function toJSONSchema(schema: unknown, name: string): Draft07 {`
`6`	`6`	`const definitions = valibotToJsonSchema(schema as any, {`
`7`	`7`	`overrideSchema(context) {`
`8`	`8`	`if (context.valibotSchema.type === 'date') {`
`9`		`- return { type: 'string', format: 'date-time' }`
	`9`	`+ return { type: 'string', format: 'date' }`
`10`	`10`	`}`
`11`	`11`	`if ((context.valibotSchema as unknown as { $content: Record<string, unknown> }).$content) {`
`12`	`12`	`return {`
Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@ export function toJSONSchema(`
`14`	`14`	`const def = ctx.zodSchema._zod?.def as unknown as Record<string, unknown>`
`15`	`15`	`if (def?.type === 'date') {`
`16`	`16`	`ctx.jsonSchema.type = 'string'`
`17`		`- ctx.jsonSchema.format = 'date-time'`
	`17`	`+ ctx.jsonSchema.format = 'date'`
`18`	`18`	`}`
`19`	`19`	`if (def?.$content) {`
`20`	`20`	`ctx.jsonSchema.$content = def.$content`