Pre-requisites

• I have double-checked my configuration
• I have tested with the :latest image tag (i.e. quay.io/argoproj/workflow-controller:latest) and can confirm the issue still exists on :latest. If not, I have explained why, in detail, in my description below.
• I have searched existing issues and could not find a match for this bug
• I'd like to contribute the fix myself (see contributing guide)

What happened? What did you expect to happen?

make test fails as below:

--- FAIL: TestStoreOperation (0.00s)
    --- PASS: TestStoreOperation/TestAddWorkflow (0.00s)
    --- PASS: TestStoreOperation/TestUpdateWorkflow (0.00s)
    --- PASS: TestStoreOperation/TestDeleteWorkflow (0.00s)
    --- PASS: TestStoreOperation/TestListWorkflows (0.00s)
    --- PASS: TestStoreOperation/TestListWorkflows_name (0.00s)
    --- PASS: TestStoreOperation/TestListWorkflows_namePrefix (0.00s)
    --- PASS: TestStoreOperation/TestListWorkflows_namePattern (0.00s)
    --- PASS: TestStoreOperation/TestListWorkflows_finishedBefore (0.00s)
    --- FAIL: TestStoreOperation/TestListWorkflows_createdAfter (0.00s)

Local TimeZone: CST

TestListWorkflows createdAfter list workflows with query:

select workflow from argo_workflows
where instanceid = ?
 and namespace = ? and json_extract(workflow, '$.metadata.creationTimestamp') >= ? order by startedat desc limit ? offset ?

metadata.creationTimestamp is UTC time, but the query input parameter is not.

Version(s)

ba3441f

Paste a minimal workflow that reproduces the issue. We must be able to run the workflow; don't enter a workflow that uses private images.

UT fails, no workflow

Logs from the workflow controller

kubectl logs -n argo deploy/workflow-controller | grep ${workflow}

Logs from in your workflow's wait container

kubectl logs -n argo -c wait -l workflows.argoproj.io/workflow=${workflow},workflow.argoproj.io/phase!=Succeeded