JavaPins - Stories tagged with oracle 10

oracle 10

atom rss
1
Pins
spam Pin it UnPin it

Improve your life Through Science and Art: Database: Part 2 - Date&Time Arithmetic with Oracle 10

published 252 days, 13 hours, 41 minutes ago posted by anishaanisha 255 days, 5 hours, 36 minutes ago
Friday, September 14, 2012 10:00:52 AM GMT Tuesday, September 11, 2012 6:05:37 PM GMT
Improve your life Through Science and Art: Database: Part 2 - Date&Time Arithmetic with Oracle 10
Formatting of the TIMESTAMP datatype Formatting of the new TIMESTAMP datatype is the same as formatting the DATE datatype. Beware while the TO_CHAR function works with both datatypes, the TRUNC function will not work with a datatype of TIMESTAMP. This is a clear indication that the use of TIMESTAMP datatype should explicitly be used for date and times.. (more)
category: SQL | clicked: 0 | comment | | source: tamanmohamed.blogspot.in
tags: Date, oracle 10, Time
1
Pins
spam Pin it UnPin it

Improve your life Through Science and Art: Database: Part1- Date&Time Arithmetic with Oracle 10

published 252 days, 13 hours, 41 minutes ago posted by anishaanisha 255 days, 5 hours, 36 minutes ago
Friday, September 14, 2012 10:00:52 AM GMT Tuesday, September 11, 2012 6:04:59 PM GMT
Improve your life Through Science and Art: Database: Part1- Date&Time Arithmetic with Oracle 10
Overview If you store date and time information in Oracle, you have two different options for the column's datatype - DATE and TIMESTAMP. DATE is the datatype that we are all familiar with when we think about representing date and time values. It has the ability to store the month, day, year, century, hours, minutes, and seconds. (more)
category: SQL | clicked: 1 | comment | | source: tamanmohamed.blogspot.in
tags: Date, oracle 10, Time