Skip to Content
author's profile photo Former Member
Former Member

Creating a date time values with 5 minute difference

PostPosted: 04 Jun 2014 08:28
Post subject: Creating 5 minute Date-time values Reply with quoteEdit/Delete this postDelete this post
Hi,

I have a requirement where I need to create a graph that has the X-axis values as Date and Timestamp. However, the values on X-axis should be of 5 minute time difference.

Can someone please help me how to achieve this?

I am using IDT 4.0 and on Teradata database.

I have a column that has timestamp values of 00:05:00, 00:10:00, ... and so on
but not sure how to get this used to increment the date object values which comes from database too.

Thanks in advance for the help.
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 04, 2014 at 08:50 AM

    can u provide an example of date????

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Shyam,

      Date Voltage

      01/01/2000 00:01:00 210

      01/01/2000 00:02:00 212

      01/01/2000 00:03:00 240

      01/01/2000 00:04:00 239

      01/01/2000 00:05:00 221

      01/01/2000 00:06:00 217

      Check bellow target table is it matching to your requirement?

      Date Voltage Terget

      01/01/2000 00:01:00 210

      01/01/2000 00:02:00 212

      01/01/2000 00:03:00 240

      01/01/2000 00:04:00 239

      01/01/2000 00:05:00 221 1122

      01/01/2000 00:06:00 217

      01/01/2000 00:07:00 200

      01/01/2000 00:08:00 300

      01/01/2000 00:09:00 400

      01/01/2000 00:10:00 500 2739


      you need to display the sum of min values at min 5 or only the 01/01/2000 00:05:00 221 , 10 min.... values in graph?


      Regards

      Riaz

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.