Home » Developer & Programmer » Forms » Time & TimeStamp
Time & TimeStamp [message #228187] Mon, 02 April 2007 00:54 Go to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hello there,

Can you tell me the difference between the data type time and the time stamp?

I want to know when I have to use the data type time stamp

Waiting your answers and thank you in advance

------
lune

Report message to a moderator

Re: Time & TimeStamp [message #228202 is a reply to message #228187] Mon, 02 April 2007 01:35 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I would suggest googling your question or searching this forum or Oracle Technology Network for 'timestamp'. Do you want to know about these things as Oracle objects or as Forms objects?

David

Report message to a moderator

Re: Time & TimeStamp [message #228454 is a reply to message #228187] Tue, 03 April 2007 02:08 Go to previous messageGo to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hi David

I have googled it and what I knew is that the stamptime will insert both the date and the time and if I insert NULL into a TimeStamp-type field, I will get automatic DateTime from the OS

That what I read about it.

My question is if I have three fields (Start_time , End Time , Date) what will be the diffrence if I choose Time or TimeStamp data type for the two fields (Start_time , End Time)

Is There Any Diffrence?


Thanks
lune

Report message to a moderator

Re: Time & TimeStamp [message #228712 is a reply to message #228454] Tue, 03 April 2007 20:47 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I ask again
Do you want to know about these things as Oracle objects or as Forms objects?

David

Report message to a moderator

Re: Time & TimeStamp [message #228768 is a reply to message #228187] Wed, 04 April 2007 02:37 Go to previous messageGo to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hello

Sorry, for that but I want to know it as Forms objects


lune

Report message to a moderator

Re: Time & TimeStamp [message #229724 is a reply to message #228768] Mon, 09 April 2007 21:05 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In Forms a 'date' field always has the time truncated. To get the date and time you need to use 'datetime'. I expect that is you used 'time' then the field would return just the 'time'.

I suggest that you experiment and see what you get. make sure that all the database fields are defined as 'date'.

Where did you see 'timestamp' in Oracle Forms?

David

Report message to a moderator

Previous Topic: last checked record problem!
Next Topic: Creating a new canvase using existing data blocks??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 12 09:55:25 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.