Normal Topic Record Timestamp (Read 409 times)
MP
Full Member
***
Offline



Posts: 104
Joined: Sep 3rd, 2007
Record Timestamp
Apr 13th, 2008 at 1:43am
Print Post Print Post  
Is there a way to get the record Timestamp (or the last modified date/time) on a record in a XResultSet?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Record Timestamp
Reply #1 - Apr 13th, 2008 at 5:05am
Print Post Print Post  
Not using a XResultSet command. You can get the timestamp of the current record by using @Timestamp, and you can set an external result set to be the current result set for the records you are viewing, and thereby set the current record.

It is probably simplest to setup a timestamp field in the records you are using. That way you get to define what constitutes a timestampable change to the data. It would also allow you to use the timestamp in a somewhat less cryptic format than seconds since Jan 1970.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
MP
Full Member
***
Offline



Posts: 104
Joined: Sep 3rd, 2007
Re: Record Timestamp
Reply #2 - Apr 13th, 2008 at 11:14am
Print Post Print Post  
Quote:
It is probably simplest to setup a timestamp field in the records you are using.


What about time zones?  I have a requirement to present times in GMT.
  
Back to top
 
IP Logged