Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get the server Date and Time 2

Status
Not open for further replies.

ultimategc3

Programmer
Oct 18, 2010
14
EG
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...
 
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
 
I want to convert my application

to web Enabled Application

i.e to use powerbuilder 11.x

or powerbuilder 12.x
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top