Convert Current System Date to CCYYMMDD

How do i take the System Date (@DATE) and convert it to CCYYMMDD.
hwdevAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
We know - you said that back on the 15th - or were you just toying with us :-)

The transform routines shouldn't be too hard to start from scratch... that second link does show you the steps - though not for date. Anyway, bit academic now, and glad you found it... Happy days !
0
 
JesterTooCommented:
Which database product are you using and what programming language?
0
 
hwdevAuthor Commented:
I am using DatasStage to try and do my conversion.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
JesterTooCommented:
Sorry, I'm not familiar with that product.

You might try looking up the various date transformation functions available for the RDBMS backend you are working with and see if you can apply them in your code.
0
 
Mark WillsTopic AdvisorCommented:
DataStage is a software product... Ascential Software DataStage, and/or Webshpere's Datastage (fromerly ascential) http://www-306.ibm.com/software/data/integration/datastage/

If (by way of example only) using Sybase as your database have a look at : http://www.sybase.com/detail?id=1035512   it does have samples down toward the bottom - basically have to create your own transform...

Other than that, go to your you will need to find out more about what it is that you are actually running...
0
 
hwdevAuthor Commented:
We are using Sybase and ASql Server as our Databases and I finally discovered an inhouse Transform routine that converts the System Date into CCYYMMDD.

Thank You
0
 
hwdevAuthor Commented:
I finally discovered an inhouse Transform routine that converts the System Date into CCYYMMDD.
0
 
hwdevAuthor Commented:
Thank you for the comments but I discovered an in house transform routine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.