August 29, 2008 10:08pm pdt

1. sdstuber 342,616
2. angelIII 92,830
3. schwertner 91,917
4. jinesh_ka... 61,095
5. sujith80 49,438
6. johnsone 46,718
7. nav_kum_v 40,079
8. DrSQL 36,755
9. MikeOM_... 35,800
10. dvz 33,200
11. joebednarz 32,246
12. sonicefu 30,106
13. Milleniuma... 26,638
14. markgeer 25,124
15. aiklamha 20,729
16. dbmullen 18,560
17. awking00 17,257
18. rolutola 14,900
19. Sqaimes 14,194
20. shajukg 12,025
21. ee_rlee 11,575
22. slightwv 11,050
23. Henka 10,300
24. Akenathon 10,004
25. sventhan 9,750

1. sdstuber 394,811
2. angelIII 238,377
3. schwertner 178,257
4. sujith80 146,594
5. nav_kum_v 103,195
6. johnsone 101,165
7. jinesh_ka... 98,695
8. markgeer 72,318
9. jwahl 67,771
10. MikeOM_... 66,800
11. YANN0S 58,155
12. slightwv 51,595
13. joebednarz 45,652
14. dvz 41,075
15. DrSQL 36,755
16. paquicuba 35,380
17. sonicefu 33,906
18. rbrooker 31,469
19. awking00 27,707
20. gattu007 27,670
21. Akenathon 27,434
22. Milleniuma... 26,638
23. LindaC 26,067
24. GGuzdziol 24,615
25. ishando 21,164

02.28.2008 at 08:04AM PST, ID: 23200715

	[x] Attachment Details

convert utc-dates to cet/cest-dates and back (considering change from daylight saving time to standard time and vice versa)

Asked by testaccount99 in Oracle 9.x, Oracle Database, Oracle 10.x

Tags: oracle, timezones, conversion utc to local time (cet/cest)

We use Oracle 9i and Oracle 10g for our applications.

All dates are stored in UTC format but in reports they should be displayed in local time format (which is CET or CEST)

e.g. 28.02.2008 10:00 (UTC) has to be displayed as 28.08.2008 11:00 (UTC +1) and
30.05.2008 12:00 (UTC) has to be displayed as 30.05.2008 14:00 (UTC +2)
independent from the date where the query is executed.

How can I convert the UTC dates correctly to local time ?Start Free Trial

Keywords: convert utc-dates to cet/cest-date…

	Title
1	GMT/UTC
2	How to convert UTC time to local time
3	converting back from UTC / GMT date
4	Converting Oracle dates to UTC format
5	Convert UTC struct tm to UTC __time…
6	Need to convert Now() into UTC

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

convert utc-dates to cet/cest-dates and back (considering change from daylight saving time to standard time and vice versa)

Asked by testaccount99 in Oracle 9.x, Oracle Database, Oracle 10.x

Tags: oracle, timezones, conversion utc to local time (cet/cest)

About this solution