WindmillWWindmill
Powered by
Trevor SullivanT
Windmill•3y ago•
1 reply
Trevor Sullivan

How do I use a Windmill Postgres script to insert a date field?

I tried this script, and it fails with the error message:
ExecutionError: error serializing parameter 2: cannot convert between the Rust type 
ExecutionError: error serializing parameter 2: cannot convert between the Rust type 
alloc::string::String
 and the Postgres type 
 and the Postgres type 
date``

-- $1 firstName
-- $2 lastName
-- $3 regDate
INSERT INTO customers (first_name, last_name, registration_date)
  VALUES ($1::TEXT, $2::TEXT, $3) RETURNING *
-- $1 firstName
-- $2 lastName
-- $3 regDate
INSERT INTO customers (first_name, last_name, registration_date)
  VALUES ($1::TEXT, $2::TEXT, $3) RETURNING *
image.png
WindmillJoin
3,362Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

How can I run a PowerShell script inside Windmill?
Trevor SullivanTTrevor Sullivan / help
3y ago
How to use ffmpeg in windmill ?
ym1198Yym1198 / help
3y ago
How to insert JSONB parameter in Postgres Action
amgfredAamgfred / help
2y ago
How to populate a field with dynamic data from a Script?
DatenDDaten / help
5mo ago