BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Date Format Question


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
fblau
Principal Member
Principal Member



Joined: 07 Feb 2005

Posts: 220



PostPosted: Wed Feb 09, 2005 1:37 pm 
Post subject: Date Format Question

My TIMEDAY table has a primary key in the form: YYYYMMDDHH24MI

How can I get that from the sysdate function?

Not being able to create my own date format strings is really a pain!!!

Frank
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10591
Location: Germany


flag
PostPosted: Thu Feb 10, 2005 2:23 am 
Post subject: Re: Date Format Question

to_char(sysdate(), 'YYYYMMDDHH24MISS') ??????

This works in case your PK is either char or number datatype. It's not datetime, isn't it?

_________________
Werner Daehn
Product Manager Data Services
SAP AG
�The opinions expressed in this post are my own views and not those of SAP.�
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17345
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Thu Feb 10, 2005 8:34 am 
Post subject: Re: Date Format Question

Frank, just a note: Please specify the software product you are working with when encountering problems: such as Data Integrator, Web Intelligence, etc. as this helps to avoid confusion.
_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0272 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0238)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo