meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 1 hour ago | |
| stats | profile views | 363 |
Oracle ACE
|
May 15 |
answered | How to load .dbf to run select queries? |
|
May 13 |
awarded | Caucus |
|
May 13 |
answered | Oracle:how to use database users as a foreign key field in any table |
|
May 3 |
comment |
Timezones in Oracle 10 @VincentMalgrat - I updated my answer to show that the results are returned based on the session's time zone. |
|
May 3 |
revised |
Timezones in Oracle 10 added 1098 characters in body |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - I updated my answer. You can't just do an AT TIME ZONE on a plain TIMESTAMP assuming you want the time component to change. Either you actually have a TIMESTAMP WITH TIME ZONE or something else is going on. |
|
May 2 |
revised |
Timezones in Oracle 10 added 1517 characters in body |
|
May 2 |
answered | Timezones in Oracle 10 |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - I guess the database could assume that any TIMESTAMP is in the database time zone. But it doesn't. If you specify TIMESTAMP rather than TIMESTAMP WITH [LOCAL] TIME ZONE, you specify that you don't care about the time zone. How much of this is dictated by the SQL 99 standard for those data types and how much is an Oracle implementation detail is not something that I know off the top of my head. |
|
May 2 |
comment |
Timezones in Oracle 10 @DylanKlomparens - The automatic conversion of time zones is something that the TIMESTAMP WITH LOCAL TIME ZONE data type does. You're not even storing a time zone with your data so Oracle has no idea that it should assume that they are UTC. |
|
May 2 |
comment |
Timezones in Oracle 10 What data type are you using to store the data? TIMESTAMP? TIMESTAMP WITH TIME ZONE? Or TIMESTAMP WITH LOCAL TIME ZONE? |
|
Apr 25 |
awarded | Enlightened |
|
Apr 24 |
answered | Is the data fetched by an explicit cursor immutable in PL/SQL? |
|
Apr 23 |
comment |
What is a partitioned view? @SuhailGupta - The documentation I linked to walks through a complete example. That is probably easier to follow than any summary I could come up with. |
|
Apr 22 |
awarded | Nice Answer |
|
Apr 21 |
answered | What is a partitioned view? |
|
Apr 15 |
reviewed | Approve suggested edit on getting error when i use merge statement |
|
Apr 8 |
comment |
Execution of a java program by a trigger What database are we talking about? Is the Java program running inside the database (i.e. a Java stored procedure in Oracle)? Or are you trying to execute an external application? Does that application reside on the database server or on a different machine? |
|
Apr 5 |
answered | double date conversion when adding partition |
|
Apr 2 |
answered | Oracle equiv of T-SQL UNION ALL query |
