Server Date/time

I need to store on a table the server date/time when a client is doing a
operation, could someone address me how I can read from a client the
server date/time ?

Best Regards
Rocco Neri

Ciao Rocco,

I use a query:

SELECT CURRENT_DATE as Data,
CURRENT_TIME as ORA
FROM TTABLE

Alessandro Romano

"Rocco Neri" <rocco.neri@NOSPAMcorael.it> ha scritto nel messaggio
news:40c5af51@wic040d....
> I need to store on a table the server date/time when a client is doing a
> operation, could someone address me how I can read from a client the
> server date/time ?
>
> Best Regards
> Rocco Neri
>
>
>

What exactly are you trying to do? If you store this data into a log-table or
similar you're better off using a monitor/extender on the server side for it.

I will put an article with step-by-step info about writing extenders/monitors
online tomorrow sometime.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm



"Rocco Neri" <rocco.neri@NOSPAMcorael.it> wrote in message
news:40c5af51@wic040d....
> I need to store on a table the server date/time when a client is doing a
> operation, could someone address me how I can read from a client the
> server date/time ?
>
> Best Regards
> Rocco Neri
>
>
>

Rocco Neri wrote:

> I need to store on a table the server date/time when a client is doing a
> operation, could someone address me how I can read from a client the
> server date/time ?
>
> Best Regards
> Rocco Neri

If your posting data using SQL then use current_timestamp. That
way it's done all server side at the moment the data is posted.

INSERT INTO NDID_STATUS
(USER,NDID_STATUS_DATE,STATUS)
VALUES
(:USER,current_timestamp,:STATUS)

If you just want to query the datetime on the server the
following will work if you have at least one table defined.

SELECT top 1 current_timestamp FROM #TABLES

Brian Evans [NDX]

dt: TDateTime;
.....
nxRemoteServerInfoPlugin1.GetServerDateTime(dt);


"Rocco Neri" <rocco.neri@NOSPAMcorael.it> wrote in message
news:40c5af51@wic040d....
> I need to store on a table the server date/time when a client is doing a
> operation, could someone address me how I can read from a client the
> server date/time ?
>
> Best Regards
> Rocco Neri
>
>
>

> I need to store on a table the server date/time when a client is doing a
> operation, could someone address me how I can read from a client the
> server date/time ?

In addition to all the ways that have been mentioned, if you move from a C/S
framework (ie just using NexusDB) to an n-tier framework (eg using NexusDB
with RemObjects/Data Abstract or kbmmw) then you can easily get the server
time as a service. You call the GetServerTime service, which is implemented
on the server side something like

begin
result := now;
end;

In fact, it's usually the first example service they walk through.

HTH,

Lauchlan M

Thanks to everybody
all your informations are very useful.
This is a great community thanks again.
Anyway I'm waiting Hannes article about extetenders/monitor

regards
Rocco


"Lauchlan M" <LMackinnon@Hotmail.com> ha scritto nel messaggio
news:40c65f33$1@wic040d....
> > I need to store on a table the server date/time when a client is doing a
> > operation, could someone address me how I can read from a client the
> > server date/time ?
>
> In addition to all the ways that have been mentioned, if you move from a
C/S
> framework (ie just using NexusDB) to an n-tier framework (eg using NexusDB
> with RemObjects/Data Abstract or kbmmw) then you can easily get the server
> time as a service. You call the GetServerTime service, which is
implemented
> on the server side something like
>
> begin
> result := now;
> end;
>
> In fact, it's usually the first example service they walk through.
>
> HTH,
>
> Lauchlan M
>
>

here's a draft - the content should be ok, it's not proof read, not beautified
and might have some wrong CSS assignment:

http://articles.nexusdb.com/articles/?id={E801B710-BF56-4074-A7D0-BAC5D279D6B1}

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm

This article is really good !

I'm also guessing that there is a wealth of similar articles tucked away
somewhere.

Are these articles accessible via your website ? A list of existing articles
would be incredibly useful to, I suspect, the majority of us.

Keep up the good work

--Steve

"Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> wrote in message
news:40c6a21a$1@wic040d....
> here's a draft - the content should be ok, it's not proof read, not
beautified
> and might have some wrong CSS assignment:
>
>
http://articles.nexusdb.com/articles/?id={E801B710-BF56-4074-A7D0-BAC5D279D6B1}
>
> --
>
> Hannes Danzl [NexusDB Developer]
> Newsgroup archive at http://www.tamaracka.com/search.htm
>
>

> This article is really good !

thanks

> I'm also guessing that there is a wealth of similar articles tucked away
> somewhere.

not so far, some are in work, lots planned. They will be integral part of the
NexusDB V2 documentation. We realized that it's almost impossible to cover the
flexibility of NexusDB with a normal manual. So we decided to improve the
manual where we can and add hands-on articles for lots of things.
we will be (sometime in the near to middle future) publish a list of articles
we want to do and ask for people for their top ten (yes it's more than ten ).

> Are these articles accessible via your website ? A list of existing articles
> would be incredibly useful to, I suspect, the majority of us.


That one and the ADO.Net/WebMatrix article are the ones that are currently in
draft version. There will be a full portal for the articles including fulltext
search in the articles very soon now.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm