Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

datetime2 not working properly #329

Open
cooltnt opened this issue Dec 8, 2022 · 0 comments
Open

datetime2 not working properly #329

cooltnt opened this issue Dec 8, 2022 · 0 comments

Comments

@cooltnt
Copy link

cooltnt commented Dec 8, 2022

sql server ddl:

CREATE TABLE [dbo].[test_datetime2](
[dt] datetime2 NULL
)

SELECT * FROM [dbo].[test_datetime2]

dt
2022-12-05 16:56:49.1812318
2022-12-05 16:57:12.6690343
2022-12-05 16:57:15.5914425
2022-12-05 16:57:16.4969742
2022-12-05 16:57:17.0174549

postgresql ddl:

CREATE foreign TABLE public.test_datetime2 (
dt timestamptz
) SERVER mssql_local OPTIONS (schema_name 'dbo', table_name 'test_datetime2');

select * from public.test_datetime2 ;

ERROR: invalid input syntax for type timestamp with time zone: "Dec 5 2022 04:56:49:1812318PM"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant