Get the server Date and Time 2

[ultimategc3]

I've a problem getting server date and time...

I'm using the today() func. to get the date and time... but some problem appears that some clients do not have the date and time synchronized with the real date and time.

is there any method to get the server date and time rather the client date and time??!


Thank you...

 

[mbalent]

You can get the date from the database using Getdate() in MS SQLServer.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[thimmava]

This works for sqlsever

write a gobal function and add this code

string Mysql
datetime ldt_server_datetime


DECLARE my_cursor DYNAMIC CURSOR FOR SQLSA ;

PREPARE SQLSA FROM "SELECT GetDate() " ;

OPEN DYNAMIC my_cursor ;

FETCH my_cursor INTO :ldt_server_datetime ;

CLOSE my_cursor ;

return ldt_server_datetime

Good luck

 

[sindbad11]

I want to convert my application

to web Enabled Application

i.e to use powerbuilder 11.x

or powerbuilder 12.x