Hello experts,
I am new in DB2. How can I store a Credit Card Expiry date (MM/YY) in DATE format?
And what is the correct syntax to insert a date, in various format?
Thanks in advane for your help.
Sagar
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
you cant just store a partial date in a date column...
I was attempting to allow you to store a valid Date for the data....
by calculating the end date of the month year combination...
that probably the best format for you anyway
Insert into testdate
( MYDATE)
Select Date('01.' concat MM concat '.' concat 'YYYY' ) + 1 Month - 1 DAY
from sysibm.sysdummy1
then you would
select substr(digits(Month(mydate
from testdate
sysibm.sysdummy1 is a table supplied by IBM as part of DB2 that contain a single row....
its used to enable various join "tricks" to be performed with your data....
this particular usage allows for direct use of functions to construct a valid date
hth
in db2 you have a column datatype called DATE, and another one called TIMESTAMP.
If you define your column as datatype DATE, then DB2 only accepts valid dates, in the form of yyyy,mo, dy, so you cannnot store '07/80' in a column defined as datatype DATE.
Similarly, you cannot store '07/80' in a column defined as datatype TIMESTAMP.
What Lowfat was trying to illustrate was that you can use a mask, also known as a default value, for the day portion of the date, which in his example was '01'-therefore all dates in your DATE datatype column would have 01 as the day. You could then decide to 'mask' this 01 value in the application by making it invisible to the user. When the user would update this field with the application, you would simply parse the year and month and add 01 as the day.
If you don't like this approach, simply define your column as datatype CHAR(5) and insert whatever values you like.
Business Accounts
Answer for Membership
by: LowfatspreadPosted on 2004-07-12 at 05:48:35ID: 11528618
which edition/version & OS for DB2?
you can try
it like this ...
Date('01.MM.YYYY') + 1 Month - 1 DAY
where you substitute in the MM and YYYY
and end up storing the end date for the Appropriate month... year combination.
e.g.
insert into yourtable
( your columns ,...)
Select your data,..., Date('01.MM.YYYY') + 1 Month - 1 DAY , ...
from sysibm.sysdummy1
hth