output of DATE function

satish mullapudi

Hi,
I am using DB v8.2. when I issuing the following stmt.:
"select DATE('25.12.2006')-DATE('24.12.2006')from sysibm.sysdummy1" :
1
"select DATE('25.12.2006')-DATE('24.11.2006')from sysibm.sysdummy1" :
101
"select DATE('25.12.2006')-DATE('25.12.2005')from sysibm.sysdummy1" :
10000
"select DATE('25.12.2006')-DATE('01.12.2005')from sysibm.sysdummy1" :
10024

can anyone please explain the reason for this sort of output.

thanks in advance.......
satish

Nov 21 '06 #1

Subscribe Post Reply

2528

Gert van der Kooij

In article <11*********************@e3g2000cwe.googlegroups.c om>,
sa***************@gmail.com says...

Hi,
I am using DB v8.2. when I issuing the following stmt.:
"select DATE('25.12.2006')-DATE('24.12.2006')from sysibm.sysdummy1" :
1
"select DATE('25.12.2006')-DATE('24.11.2006')from sysibm.sysdummy1" :
101
"select DATE('25.12.2006')-DATE('25.12.2005')from sysibm.sysdummy1" :
10000
"select DATE('25.12.2006')-DATE('01.12.2005')from sysibm.sysdummy1" :
10024

can anyone please explain the reason for this sort of output.

thanks in advance.......
satish

That's a date duration, check the docs at http://tinyurl.com/tt6sc for
'labeled durations'.

Nov 21 '06 #2

Knut Stolze

satish mullapudi wrote:

Hi,
I am using DB v8.2. when I issuing the following stmt.:
"select DATE('25.12.2006')-DATE('24.12.2006')from sysibm.sysdummy1" :
1

The interval is 00000001, i.e. 1 day.

"select DATE('25.12.2006')-DATE('24.11.2006')from sysibm.sysdummy1" :
101

The interval is 1 month and 1 day.

"select DATE('25.12.2006')-DATE('25.12.2005')from sysibm.sysdummy1" :
10000

The interval is 1 year, 0 months (digts 2-3), and 0 days (last 2 digits).

"select DATE('25.12.2006')-DATE('01.12.2005')from sysibm.sysdummy1" :
10024

The interval is 1 year, 0 months, and 24 days.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 21 '06 #3

satish mullapudi

thanq....

Knut Stolze wrote:

satish mullapudi wrote:

Hi,
I am using DB v8.2. when I issuing the following stmt.:
"select DATE('25.12.2006')-DATE('24.12.2006')from sysibm.sysdummy1" :
1

The interval is 00000001, i.e. 1 day.

"select DATE('25.12.2006')-DATE('24.11.2006')from sysibm.sysdummy1" :
101

The interval is 1 month and 1 day.

"select DATE('25.12.2006')-DATE('25.12.2005')from sysibm.sysdummy1" :
10000

The interval is 1 year, 0 months (digts 2-3), and 0 days (last 2 digits).

"select DATE('25.12.2006')-DATE('01.12.2005')from sysibm.sysdummy1" :
10024

The interval is 1 year, 0 months, and 24 days.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 23 '06 #4

Similar topics

making gmdate output equal date output

by: yawnmoth | last post by:

gmdate('F j, Y, g:i a',0) returns January 1, 1970, 12:00 am. How do I add to the second parameter of the date function to make it always return that same date, regardless of the time zone?...

PHP

Apache/2.0.54 (Win32) PHP/5.0.5 multiple output

by: Thomas Hermann | last post by:

A newbie question: With the config mentioned in the topic, all on localhost, Win xpsp2, i created a caledar-table. The output should be a daily calendar for half a year with about 15 cols. ...

PHP

Function to Append DATE to output tablename for Make Table Query

by: Mo Ka | last post by:

Hi all, Is there a function (or other method) to automatically append the system date to the output tablename of a make table query such that the new one does not overwrite an older table?. I...

Microsoft Access / VBA

MS-SQL Sprocs - looping,case,output parameters and 12 cents

by: Lyle Fairfield | last post by:

The stored procedure script below is an example of how looping, case statements and output parameters can be used in MS-SQL stored procedures to accomplish things for which we may have had to use...

Microsoft Access / VBA

Template Language: [!output .......]

by: Michael Maes | last post by:

Hello, I want to add a date (ShortDateString) to a custom template-file (Class). I use: a.. b.. c.. But I can't find anythig on a date (something like: )

Visual Basic .NET

Javascript Date Validation in MM/DD/YYY output format

by: pmarisole | last post by:

The following javascript code gives me the date validation that I need except after the correct date is entered into the field, it puts the date in the wrong format EXAMPLE: User enters...

Javascript

Output stored procdure in datasheet-view without using a form

by: Filips Benoit | last post by:

Dear All, How can I show the resultrecords of a SP. I can be done by doubleclick the SPname? But how to do it by code. I want the following interface In my form the user 1 selects a SP...

Microsoft Access / VBA

Output file prob

by: Savage | last post by:

I'm making for fun a simple program which format a input file.Input file sustain of person name,lastname and date of birth.Output file si supposed to be forammted as following: NAME ...

C / C++

Adding Image to an Output.

by: xxtokenxx | last post by:

I am writing a birthday list for a site for my school. While developing it. Currently the code for the output of birthdays is: <html><head> <title>Birthday List</title><script...

Javascript

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware