Convert Current System Date to CCYYMMDD
How do i take the System Date (@DATE) and convert it to CCYYMMDD.
JesterToo
Which database product are you using and what programming language?
ASKER
I am using DatasStage to try and do my conversion.
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.
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.
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...
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...
ASKER
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
Thank You
ASKER
I finally discovered an inhouse Transform routine that converts the System Date into CCYYMMDD.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the comments but I discovered an in house transform routine.