nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date column switching to v_Wstring in SQL

imaran_669

Dear community, I’m having an issue here that is driving me crazy. Why all my date columns in a workflow (date validated right before output) are written like v_WString in SQL?

It’s weird, I see the columns go as date in the output and when I read the newly created table the columns appear like v_WString of 10 of length.

Any ideas?

Regards!!!

Date Time

Accepted answers

imaran_669

Thx for the help... found the solution:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-data-type-changes-to-v-string-when-connected-via-in-db-SQL/td-p/540880

Just tested it and works ok

All comments

apathetichell

what kind of sql - ie what kind of database are you writing to - are you appending or creating something new? Are you writing In-DB or using Datastream In?

Can you share some screen grabs of your data?

imaran_669

Sure, here is the problem in a more visual way. I need to add that the problem is with all worfklows that contain Date columns, not only this one.

apathetichell

Sorry - this doesn't really tell me much. can you try writing via datastream in. Can you try reading via Connect In-DB. Can you add a select In-DB? I don't really know what the underlying schema of your table is - and did you specify what your DB is?

imaran_669

Ok, i did some more testing. Looks that if I change the field to DateTime field is created correcly. Dont get why it doesnt work with just date. Sucks to have a bunch of 00:00:00.000 at the end of each date.

apathetichell

Perhaps if you explained what kind of DB you were running we might be able to help more? I can tell you for example that this is not true on: Snowflake, Redshift, Postgres, Databricks, BigQuery... so....

imaran_669

Thx for the help... found the solution:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-data-type-changes-to-v-string-when-connected-via-in-db-SQL/td-p/540880

Just tested it and works ok

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703