Creating a date time values with 5 minute difference

[Former Member]

Posted: 04 Jun 2014 08:28 Post subject: Creating 5 minute Date-time values
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.

[saurabh_sonawane]

can u provide an example of date????

[Former Member]

Hi Saurabh,

Thanks for the quick reply.

I need an X-axis value to be displayed as 01/01/2013 00:05:00, 01/01/2013 00:10:00, 01/01/2013 00:15:00, and so on....

The above has a time difference of 5 minutes.

[Former Member]

Sorry, just to add one more point.

I do have a date column that comes from the database and its specific other column values

however, the requirement is to have a graph that shows the data for every 5 minutes as mentioned above.

I have a date column with date values as

01/01/2013. 05/06/2013 ... all the database values

I got a timestamp column created so that i could use and that is 00:05:00, 00:10:00, 00:15:00, ...etc

[saurabh_sonawane]

provide a sample data also

means

date     time

1/1/14   00:05:00

1/1/14   00:10:00

[former_member193866]

Hi Shyam,

Merge both time and date objects.Take combination of merge object and measure objects to create chart.

Regards

Riaz

[Former Member]

Hi Riaz,

Thankyou for your reply

Can you please explain a bit more.

[Former Member]

Hi Saurabh,

I would have data as

Date                  voltage

01/01/2013          200

05/06/2013           210

09/02/2014          222

The database has values for every minute.

But now I need to show the values for every 5 minutes only.

[former_member193866]

Hi Shyam,

The data which you have provided is for different years and different dates. you are saying you have data for every min...

Do you have every min data for single year or different years. What is your exact requirement plz share a screen shot by drawing.

Regards

Riaz

[Former Member]

Hi Saurabh,

Yes I do have data for every minute and now i want it to show for only every 5 minutes.

For example:

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

Please let me know if you require more information on this.

[former_member193866]

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