You are not logged in.
- Topics: Active | Unanswered
Announcement
Migration of this forum
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
- Each user will need to reset their password.
- Please select "I forgot my password".
- Enter the email address you used to register in this forum.
- You will receive an email with a link to set a new password.
- Please choose a new (secure) password and confirm the process.
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Migration des Forums
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
- Jeder Nutzer muss sein Passwort neu vergeben.
- Wählt dazu einfach "Ich habe mein Passwort vergessen".
- Gebt die E-Mail-Adresse ein, mit der ihr registriert seid.
- Ihr erhaltet eine E-Mail mit einem Link zur Passwortvergabe.
- Bitte wählt ein neues (sicheres) Passwort und bestätigt den Vorgang.
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Pages: 1
#1 2023-05-30 21:16:43
- Enrique
- Member
- Registered: 2020-12-04
when converting to local timezone
Hello Team,
Since a while that i haven't posted here searchig for good advices is there any one here that had faced this error when working with conversion of date time stamp globally, for example I know that the database is not on my own timezone it is in Europe and I'm from Mexico, what i want to accomplish is only convert the data into my local timezone but when executing this SQL i got the the error described in the image.
What i need is only to have the date time conversion from Europe to Mexico time, having the 7 hours difference between one and the other.
"The report could not be executed : IllegalArgumentException: Could not map -101 to java class"
"An example of the value in the column is : "2023-05-24 16:25:50.531656"
Oracle sql:
SELECT
FECHA_Y_HORA_DE_MOVIMIENTO
FROM (SELECT
FROM_TZ(CAST(ii.DSTAMP AS TIMESTAMP), 'UTC') AT TIME ZONE 'America/Mexico_City' as FECHA_Y_HORA_DE_MOVIMIENTO
FROM INVENTORY_TRANSACTION ii RIGHT OUTER JOIN ORDER_HEADER jj ON (ii.REFERENCE_ID = jj.ORDER_ID)
WHERE ii.SITE_ID LIKE '%MX%'
AND ii.code = 'Shipment'
AND ii.DSTAMP between next_day(sysdate - 14, 'monday') and next_day(sysdate - 7, 'sunday'))
Offline
#2 2023-05-31 08:56:40
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: when converting to local timezone
Hi Enrique,
1. Pls post a complete screenshot of Administration -> System console -> General Info (you can use http://imgbb.com for that)
2. Can you pls simplify (minimize) your query so that it only contains the necessary for reproducing the problem ? something like
Select CONVERT('2023-05-24 16:25:50.531656') as myDate where CONVERT is your function. So we can reproduce the problem.
3. what db exactly are you using for this datasource?
Regards,
Eduardo
Offline
Pages: 1