[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2561
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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