Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: date and time funtcion Post Reply Post New Topic
Author Message
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Topic: date and time funtcion
     Posted: 05 Nov 2009 at 10:16am
i have a problem in retrieving data from the database. in my database, i have a column that consist date and time (format in dd-mm-yyyy 00:00). how can i retrieve the data with the whole data format (dd-mm-yyyy 00:00). what function can i use? please advice
 
thank you in advance.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 06 Nov 2009 at 6:48am

don't understand the question as both formats are the same.  Do you want to retrieve data that has a time and display it as if it didn't?

If you don't care about the time, don't display it, what is the point of displaying the time if you are forcing it to be the same.

IP IP Logged
lalakeyorai
Newbie
Newbie


Joined: 01 Nov 2009
Online Status: Offline
Posts: 19
Quote lalakeyorai Replybullet Posted: 08 Nov 2009 at 10:59pm
thank you for your reply... i sorry if im not making you clear about what im trying to do.
 
i would like to display date and time format to my chart. i've tried to create a chart with time on the x-axis. i currently im using
 
time ({@Event_Update_time}) - (where this field consist time in bigint number that i have converted to the readable format time)
 
For the above command, there were only time displayed on the x-axis. when i try change to 'datetime ({@Event_Updtae_Time})', there was an error occured saying that "A date is required here". how can i make it my chart display date and time on the x-axis.
 
thank you.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum