[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2559
  • Last Modified:

Convert Current System Date to CCYYMMDD

How do i take the System Date (@DATE) and convert it to CCYYMMDD.
0
hwdev
Asked:
hwdev
  • 4
  • 2
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Mark WillsTopic 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
 
hwdevAuthor Commented:
Thank you for the comments but I discovered an in house transform routine.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now