Teradata Community

Tag: "timestamp" in "Database"

Database
Options
  • 40 posts
  • |
  • 2 taggers
  • |
  • First used:
  • ‎09-08-2016
Latest Tagged
ehbhaskar

Compression on timestamp column - ( ‎01-19-2017 10:51 AM )

Database
by ehbhaskar on ‎01-19-2017 10:51 AM Latest post on ‎01-19-2017 12:52 PM by oshun
1 Reply 7653 Views
1 Reply
7653 Views
Nishant_Bhardwa

Converions of timestamp to FORMAT 'MM/DD/YYYYBHH:M... - ( ‎01-24-2014 06:35 AM )

Database
by Nishant_Bhardwa on ‎01-24-2014 06:35 AM Latest post on ‎04-26-2017 07:35 AM by
9 Replies 50299 Views
9 Replies
50299 Views
m_tahoon

Huge Cardinality estimates for TIMESTAMP COLUMNS - ( ‎07-12-2012 09:26 AM )

Database
by m_tahoon on ‎07-12-2012 09:26 AM Latest post on ‎07-15-2012 09:01 AM by
7 Replies 10527 Views
7 Replies
10527 Views
smiehu

Detect and fix overlapping timestamps by their ran... - ( ‎09-14-2015 08:51 AM )

Database
by smiehu on ‎09-14-2015 08:51 AM Latest post on ‎10-20-2015 03:11 AM by smiehu
4 Replies 12587 Views
4 Replies
12587 Views
ASR

Converting CHAR to DATE - ( ‎05-09-2012 02:01 AM )

Database
by ASR on ‎05-09-2012 02:01 AM Latest post on ‎06-26-2012 11:40 AM by D3V1L
4 Replies 12485 Views
4 Replies
12485 Views
CChandl

Timestamp TimeZone Cleaner Coding - ( ‎07-09-2015 08:34 AM )

Database
by CChandl on ‎07-09-2015 08:34 AM Latest post on ‎07-15-2015 01:55 AM by
1 Reply 5340 Views
1 Reply
5340 Views
dsaini

Error Msg 2666 - ( ‎12-13-2012 11:31 AM )

Database
by dsaini on ‎12-13-2012 11:31 AM
0 Replies 3054 Views
0 Replies
3054 Views
Chopper1979

Count of Records within 7 days of Timestamp - ( ‎04-10-2013 09:02 AM )

Database
by Chopper1979 on ‎04-10-2013 09:02 AM Latest post on ‎04-11-2013 01:56 AM by Chopper1979
2 Replies 6939 Views
2 Replies
6939 Views
Angellore

CLIv2 program and TimeStamp - ( ‎02-02-2014 12:27 PM )

Database
by Angellore on ‎02-02-2014 12:27 PM Latest post on ‎02-03-2014 10:06 PM by Adeel_Chaudhry
4 Replies 11272 Views
4 Replies
11272 Views
gpolanch

Unexpected syntax error 3706 when using CASE IN wi... - ( ‎02-09-2012 01:19 PM )

Database
by gpolanch on ‎02-09-2012 01:19 PM Latest post on ‎02-10-2012 11:46 AM by ulrich
6 Replies 10072 Views
6 Replies
10072 Views
Piotr_Skrzypiec

partitioning on DATE or TIMESTAMP - ( ‎07-30-2014 09:04 AM )

Database
by Piotr_Skrzypiec on ‎07-30-2014 09:04 AM
0 Replies 3953 Views
0 Replies
3953 Views
sk8s3i

Timestamp for the previous day - ( ‎10-08-2014 08:23 AM )

Database
by sk8s3i on ‎10-08-2014 08:23 AM Latest post on ‎10-08-2014 08:44 AM by sk8s3i
2 Replies 6015 Views
2 Replies
6015 Views
dlabar

Number of seconds elapsed since beginning of day - ( ‎01-22-2013 09:59 AM )

Database
by dlabar on ‎01-22-2013 09:59 AM Latest post on ‎01-23-2013 07:02 AM by dlabar
2 Replies 7230 Views
2 Replies
7230 Views
tclear

Table Load Timestamp - ( ‎06-26-2012 11:56 AM )

Database
by tclear on ‎06-26-2012 11:56 AM Latest post on ‎07-05-2012 06:40 AM by ulrich
7 Replies 14865 Views
7 Replies
14865 Views
Jithin_James

How to Import these data into teradata DB using SQ... - ( ‎05-31-2016 09:53 AM )

Database
by Jithin_James on ‎05-31-2016 09:53 AM Latest post on ‎06-01-2016 12:52 AM by AtardecerR0j0
1 Reply 5971 Views
1 Reply
5971 Views
dieter

data timestamp issues - ( ‎01-15-2015 06:44 AM )

Database
by dieter on ‎01-15-2015 06:44 AM Latest post on ‎01-16-2015 01:43 AM by
3 Replies 9538 Views
3 Replies
9538 Views
info9891

How do I convert a date or timestamp to a string i... - ( ‎09-08-2014 07:11 PM )

Database
by info9891 on ‎09-08-2014 07:11 PM Latest post on ‎09-09-2014 02:01 AM by reddyrajendra20
2 Replies 12895 Views
2 Replies
12895 Views
InTransition

Converting a TIMESTAMP(6) to a TIMESTAMP(0) for In... - ( ‎03-23-2011 11:52 AM )

Database
by InTransition on ‎03-23-2011 11:52 AM Latest post on ‎03-08-2017 10:19 AM by Fred
6 Replies 28266 Views
6 Replies
28266 Views
yarekshy85

Convert text to a timestamp - ( ‎06-13-2016 06:01 PM )

Database
by yarekshy85 on ‎06-13-2016 06:01 PM Latest post on ‎08-10-2016 12:31 AM by Inguva
3 Replies 10992 Views
3 Replies
10992 Views
Fernando_Araujo

Timestamp Difference in Minutes (without using Per... - ( ‎03-12-2012 03:02 AM )

Database
by Fernando_Araujo on ‎03-12-2012 03:02 AM Latest post on ‎03-12-2012 03:43 AM by Fernando_Araujo
2 Replies 13712 Views
2 Replies
13712 Views
ppad001

Timestamp Datatype - ( ‎09-06-2011 05:22 AM )

Database
by ppad001 on ‎09-06-2011 05:22 AM Latest post on ‎12-26-2011 04:10 AM by skatepalli
3 Replies 12007 Views
3 Replies
12007 Views
teradatatester

TPT - TIMESTAMP FORMAT - century of '19' instead o... - ( ‎03-28-2011 03:36 PM )

Database
by teradatatester on ‎03-28-2011 03:36 PM Latest post on ‎03-28-2011 11:25 PM by
1 Reply 4855 Views
1 Reply
4855 Views
Brucemzhu

How to convert UTC millisecond to Timestamp(6) - ( ‎08-23-2015 10:51 PM )

Database
by Brucemzhu on ‎08-23-2015 10:51 PM Latest post on ‎03-18-2016 11:39 AM by PS186010
6 Replies 14874 Views
6 Replies
14874 Views
bkj123

backups and timestamps in table names - ( ‎09-27-2013 09:22 AM )

Database
by bkj123 on ‎09-27-2013 09:22 AM Latest post on ‎09-30-2013 09:01 AM by bkj123
2 Replies 6642 Views
2 Replies
6642 Views
mandeep_m91

Is it possible to handle the date in format YYYY-M... - ( ‎05-08-2013 05:10 AM )

Database
by mandeep_m91 on ‎05-08-2013 05:10 AM Latest post on ‎05-16-2013 11:28 AM by mandeep_m91
2 Replies 8101 Views
2 Replies
8101 Views
shura1204

Convert timestamp to format ISO 8061 - ( ‎04-04-2011 11:17 AM )

Database
by shura1204 on ‎04-04-2011 11:17 AM Latest post on ‎04-06-2011 01:28 PM by
1 Reply 5790 Views
1 Reply
5790 Views
n_shashi

COMPRESSION for TIMESTAMP field in TD14 - ( ‎03-07-2014 08:07 PM )

Database
by n_shashi on ‎03-07-2014 08:07 PM Latest post on ‎03-16-2015 03:45 PM by lawrence_lakey
6 Replies 18501 Views
6 Replies
18501 Views
balu_td

Timestamp format not working to get the two digit ... - ( ‎03-06-2013 09:13 AM )

Database
by balu_td on ‎03-06-2013 09:13 AM Latest post on ‎03-06-2013 12:32 PM by balu_td
1 Reply 5618 Views
1 Reply
5618 Views
pajtasja

SELECT MAX(timeValue), MIN(timevalue) FROM OurDB.D... - ( ‎01-14-2014 01:41 PM )

Database
by pajtasja on ‎01-14-2014 01:41 PM Latest post on ‎01-16-2014 01:53 PM by pajtasja
3 Replies 8968 Views
3 Replies
8968 Views
teradatatester

Integer (with Unix epoch time) convert to timestam... - ( ‎04-06-2011 01:22 PM )

Database
by teradatatester on ‎04-06-2011 01:22 PM Latest post on ‎04-06-2011 06:05 PM by teradatatester
2 Replies 7514 Views
2 Replies
7514 Views
SofiaVer

Casting timestamp to date and to char - ( ‎11-15-2012 06:11 AM )

Database
by SofiaVer on ‎11-15-2012 06:11 AM Latest post on ‎11-16-2012 12:20 PM by SofiaVer
4 Replies 25153 Views
4 Replies
25153 Views
balu_td

Timestamp format not working to get the two digit ... - ( ‎03-06-2013 01:24 PM )

Database
by balu_td on ‎03-06-2013 01:24 PM Latest post on ‎03-10-2013 05:24 AM by rajeev_saravana
11 Replies 23635 Views
11 Replies
23635 Views
valks97

Using case when with a timestamp in the select sta... - ( ‎06-23-2015 02:32 PM )

Database
by valks97 on ‎06-23-2015 02:32 PM Latest post on ‎06-27-2015 02:59 AM by
3 Replies 9482 Views
3 Replies
9482 Views
teradatatester

TIMESTAMP: FORMAT - TimeZone - ( ‎04-08-2011 07:25 PM )

Database
by teradatatester on ‎04-08-2011 07:25 PM Latest post on ‎04-11-2011 08:16 AM by kostek
1 Reply 5402 Views
1 Reply
5402 Views
SAP

SQLServer - Teradata Timestamp Issue - ( ‎11-13-2014 07:59 PM )

Database
by SAP on ‎11-13-2014 07:59 PM Latest post on ‎11-14-2014 04:21 PM by Fred
2 Replies 7595 Views
2 Replies
7595 Views
anandc

Minmum Time field selection - TIME(6) - ( ‎10-11-2013 11:25 AM )

Database
by anandc on ‎10-11-2013 11:25 AM Latest post on ‎10-15-2013 08:09 AM by anandc
6 Replies 12509 Views
6 Replies
12509 Views
janus

Extraction of time from timestamp! - ( ‎02-12-2010 06:36 AM )

Database
by janus on ‎02-12-2010 06:36 AM Latest post on ‎02-12-2010 11:09 AM by janus
1 Reply 6339 Views
1 Reply
6339 Views
OM186000

Varchar to Timestamp(6) conversion - ( ‎08-12-2014 05:38 PM )

Database
by OM186000 on ‎08-12-2014 05:38 PM Latest post on ‎08-15-2014 04:54 AM by
1 Reply 5523 Views
1 Reply
5523 Views
jpw111082

Error when trying to create a function - ( ‎06-30-2016 01:00 PM )

Database
by jpw111082 on ‎06-30-2016 01:00 PM Latest post on ‎06-30-2016 11:20 PM by
1 Reply 5978 Views
1 Reply
5978 Views
balu_td

Load clm with 12 hour time format - ( ‎03-29-2013 08:07 AM )

Database
by balu_td on ‎03-29-2013 08:07 AM Latest post on ‎03-29-2013 12:56 PM by KS42982
1 Reply 5752 Views
1 Reply
5752 Views
Top Tagged
ehbhaskar

Compression on timestamp column - ( ‎01-19-2017 10:51 AM )

Database
by ehbhaskar on ‎01-19-2017 10:51 AM Latest post on ‎01-19-2017 12:52 PM by oshun
1 Reply 7653 Views
1 Reply
7653 Views
m_tahoon

Huge Cardinality estimates for TIMESTAMP COLUMNS - ( ‎07-12-2012 09:26 AM )

Database
by m_tahoon on ‎07-12-2012 09:26 AM Latest post on ‎07-15-2012 09:01 AM by
7 Replies 10527 Views
7 Replies
10527 Views
OM186000

Varchar to Timestamp(6) conversion - ( ‎08-12-2014 05:38 PM )

Database
by OM186000 on ‎08-12-2014 05:38 PM Latest post on ‎08-15-2014 04:54 AM by
1 Reply 5523 Views
1 Reply
5523 Views
teradatatester

TIMESTAMP: FORMAT - TimeZone - ( ‎04-08-2011 07:25 PM )

Database
by teradatatester on ‎04-08-2011 07:25 PM Latest post on ‎04-11-2011 08:16 AM by kostek
1 Reply 5402 Views
1 Reply
5402 Views
teradatatester

Integer (with Unix epoch time) convert to timestam... - ( ‎04-06-2011 01:22 PM )

Database
by teradatatester on ‎04-06-2011 01:22 PM Latest post on ‎04-06-2011 06:05 PM by teradatatester
2 Replies 7514 Views
2 Replies
7514 Views
shura1204

Convert timestamp to format ISO 8061 - ( ‎04-04-2011 11:17 AM )

Database
by shura1204 on ‎04-04-2011 11:17 AM Latest post on ‎04-06-2011 01:28 PM by
1 Reply 5790 Views
1 Reply
5790 Views
teradatatester

TPT - TIMESTAMP FORMAT - century of '19' instead o... - ( ‎03-28-2011 03:36 PM )

Database
by teradatatester on ‎03-28-2011 03:36 PM Latest post on ‎03-28-2011 11:25 PM by
1 Reply 4855 Views
1 Reply
4855 Views
InTransition

Converting a TIMESTAMP(6) to a TIMESTAMP(0) for In... - ( ‎03-23-2011 11:52 AM )

Database
by InTransition on ‎03-23-2011 11:52 AM Latest post on ‎03-08-2017 10:19 AM by Fred
6 Replies 28266 Views
6 Replies
28266 Views
tclear

Table Load Timestamp - ( ‎06-26-2012 11:56 AM )

Database
by tclear on ‎06-26-2012 11:56 AM Latest post on ‎07-05-2012 06:40 AM by ulrich
7 Replies 14865 Views
7 Replies
14865 Views
Piotr_Skrzypiec

partitioning on DATE or TIMESTAMP - ( ‎07-30-2014 09:04 AM )

Database
by Piotr_Skrzypiec on ‎07-30-2014 09:04 AM
0 Replies 3953 Views
0 Replies
3953 Views
Chopper1979

Count of Records within 7 days of Timestamp - ( ‎04-10-2013 09:02 AM )

Database
by Chopper1979 on ‎04-10-2013 09:02 AM Latest post on ‎04-11-2013 01:56 AM by Chopper1979
2 Replies 6939 Views
2 Replies
6939 Views
ASR

Converting CHAR to DATE - ( ‎05-09-2012 02:01 AM )

Database
by ASR on ‎05-09-2012 02:01 AM Latest post on ‎06-26-2012 11:40 AM by D3V1L
4 Replies 12485 Views
4 Replies
12485 Views
balu_td

Load clm with 12 hour time format - ( ‎03-29-2013 08:07 AM )

Database
by balu_td on ‎03-29-2013 08:07 AM Latest post on ‎03-29-2013 12:56 PM by KS42982
1 Reply 5752 Views
1 Reply
5752 Views
anandc

Minmum Time field selection - TIME(6) - ( ‎10-11-2013 11:25 AM )

Database
by anandc on ‎10-11-2013 11:25 AM Latest post on ‎10-15-2013 08:09 AM by anandc
6 Replies 12509 Views
6 Replies
12509 Views
balu_td

Timestamp format not working to get the two digit ... - ( ‎03-06-2013 01:24 PM )

Database
by balu_td on ‎03-06-2013 01:24 PM Latest post on ‎03-10-2013 05:24 AM by rajeev_saravana
11 Replies 23635 Views
11 Replies
23635 Views
balu_td

Timestamp format not working to get the two digit ... - ( ‎03-06-2013 09:13 AM )

Database
by balu_td on ‎03-06-2013 09:13 AM Latest post on ‎03-06-2013 12:32 PM by balu_td
1 Reply 5618 Views
1 Reply
5618 Views
bkj123

backups and timestamps in table names - ( ‎09-27-2013 09:22 AM )

Database
by bkj123 on ‎09-27-2013 09:22 AM Latest post on ‎09-30-2013 09:01 AM by bkj123
2 Replies 6642 Views
2 Replies
6642 Views
Fernando_Araujo

Timestamp Difference in Minutes (without using Per... - ( ‎03-12-2012 03:02 AM )

Database
by Fernando_Araujo on ‎03-12-2012 03:02 AM Latest post on ‎03-12-2012 03:43 AM by Fernando_Araujo
2 Replies 13712 Views
2 Replies
13712 Views
dieter

data timestamp issues - ( ‎01-15-2015 06:44 AM )

Database
by dieter on ‎01-15-2015 06:44 AM Latest post on ‎01-16-2015 01:43 AM by
3 Replies 9538 Views
3 Replies
9538 Views
dlabar

Number of seconds elapsed since beginning of day - ( ‎01-22-2013 09:59 AM )

Database
by dlabar on ‎01-22-2013 09:59 AM Latest post on ‎01-23-2013 07:02 AM by dlabar
2 Replies 7230 Views
2 Replies
7230 Views
gpolanch

Unexpected syntax error 3706 when using CASE IN wi... - ( ‎02-09-2012 01:19 PM )

Database
by gpolanch on ‎02-09-2012 01:19 PM Latest post on ‎02-10-2012 11:46 AM by ulrich
6 Replies 10072 Views
6 Replies
10072 Views
dsaini

Error Msg 2666 - ( ‎12-13-2012 11:31 AM )

Database
by dsaini on ‎12-13-2012 11:31 AM
0 Replies 3054 Views
0 Replies
3054 Views
smiehu

Detect and fix overlapping timestamps by their ran... - ( ‎09-14-2015 08:51 AM )

Database
by smiehu on ‎09-14-2015 08:51 AM Latest post on ‎10-20-2015 03:11 AM by smiehu
4 Replies 12587 Views
4 Replies
12587 Views
jpw111082

Error when trying to create a function - ( ‎06-30-2016 01:00 PM )

Database
by jpw111082 on ‎06-30-2016 01:00 PM Latest post on ‎06-30-2016 11:20 PM by
1 Reply 5978 Views
1 Reply
5978 Views
SAP

SQLServer - Teradata Timestamp Issue - ( ‎11-13-2014 07:59 PM )

Database
by SAP on ‎11-13-2014 07:59 PM Latest post on ‎11-14-2014 04:21 PM by Fred
2 Replies 7595 Views
2 Replies
7595 Views
SofiaVer

Casting timestamp to date and to char - ( ‎11-15-2012 06:11 AM )

Database
by SofiaVer on ‎11-15-2012 06:11 AM Latest post on ‎11-16-2012 12:20 PM by SofiaVer
4 Replies 25153 Views
4 Replies
25153 Views
n_shashi

COMPRESSION for TIMESTAMP field in TD14 - ( ‎03-07-2014 08:07 PM )

Database
by n_shashi on ‎03-07-2014 08:07 PM Latest post on ‎03-16-2015 03:45 PM by lawrence_lakey
6 Replies 18501 Views
6 Replies
18501 Views
Brucemzhu

How to convert UTC millisecond to Timestamp(6) - ( ‎08-23-2015 10:51 PM )

Database
by Brucemzhu on ‎08-23-2015 10:51 PM Latest post on ‎03-18-2016 11:39 AM by PS186010
6 Replies 14874 Views
6 Replies
14874 Views
yarekshy85

Convert text to a timestamp - ( ‎06-13-2016 06:01 PM )

Database
by yarekshy85 on ‎06-13-2016 06:01 PM Latest post on ‎08-10-2016 12:31 AM by Inguva
3 Replies 10992 Views
3 Replies
10992 Views
Jithin_James

How to Import these data into teradata DB using SQ... - ( ‎05-31-2016 09:53 AM )

Database
by Jithin_James on ‎05-31-2016 09:53 AM Latest post on ‎06-01-2016 12:52 AM by AtardecerR0j0
1 Reply 5971 Views
1 Reply
5971 Views
sk8s3i

Timestamp for the previous day - ( ‎10-08-2014 08:23 AM )

Database
by sk8s3i on ‎10-08-2014 08:23 AM Latest post on ‎10-08-2014 08:44 AM by sk8s3i
2 Replies 6015 Views
2 Replies
6015 Views
Angellore

CLIv2 program and TimeStamp - ( ‎02-02-2014 12:27 PM )

Database
by Angellore on ‎02-02-2014 12:27 PM Latest post on ‎02-03-2014 10:06 PM by Adeel_Chaudhry
4 Replies 11272 Views
4 Replies
11272 Views
CChandl

Timestamp TimeZone Cleaner Coding - ( ‎07-09-2015 08:34 AM )

Database
by CChandl on ‎07-09-2015 08:34 AM Latest post on ‎07-15-2015 01:55 AM by
1 Reply 5340 Views
1 Reply
5340 Views
Nishant_Bhardwa

Converions of timestamp to FORMAT 'MM/DD/YYYYBHH:M... - ( ‎01-24-2014 06:35 AM )

Database
by Nishant_Bhardwa on ‎01-24-2014 06:35 AM Latest post on ‎04-26-2017 07:35 AM by
9 Replies 50299 Views
9 Replies
50299 Views
janus

Extraction of time from timestamp! - ( ‎02-12-2010 06:36 AM )

Database
by janus on ‎02-12-2010 06:36 AM Latest post on ‎02-12-2010 11:09 AM by janus
1 Reply 6339 Views
1 Reply
6339 Views
valks97

Using case when with a timestamp in the select sta... - ( ‎06-23-2015 02:32 PM )

Database
by valks97 on ‎06-23-2015 02:32 PM Latest post on ‎06-27-2015 02:59 AM by
3 Replies 9482 Views
3 Replies
9482 Views
pajtasja

SELECT MAX(timeValue), MIN(timevalue) FROM OurDB.D... - ( ‎01-14-2014 01:41 PM )

Database
by pajtasja on ‎01-14-2014 01:41 PM Latest post on ‎01-16-2014 01:53 PM by pajtasja
3 Replies 8968 Views
3 Replies
8968 Views
mandeep_m91

Is it possible to handle the date in format YYYY-M... - ( ‎05-08-2013 05:10 AM )

Database
by mandeep_m91 on ‎05-08-2013 05:10 AM Latest post on ‎05-16-2013 11:28 AM by mandeep_m91
2 Replies 8101 Views
2 Replies
8101 Views
ppad001

Timestamp Datatype - ( ‎09-06-2011 05:22 AM )

Database
by ppad001 on ‎09-06-2011 05:22 AM Latest post on ‎12-26-2011 04:10 AM by skatepalli
3 Replies 12007 Views
3 Replies
12007 Views
info9891

How do I convert a date or timestamp to a string i... - ( ‎09-08-2014 07:11 PM )

Database
by info9891 on ‎09-08-2014 07:11 PM Latest post on ‎09-09-2014 02:01 AM by reddyrajendra20
2 Replies 12895 Views
2 Replies
12895 Views
Teradata Links
Teradata.com Teradata Partners
Support & Forums
Teradata Support Support Portal / TaYS Teradata Enhancement Requests Teradata Aster Community Communities
Downloads
Documentation Developer Downloads Teradata Express Teradata Aster Express Teradata Aster Development Environment
Community Feedback

Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.

The Privacy Policy and Terms of Use for this Teradata website changed effective September 8, 2016.