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!

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

Get Date??

Status
Not open for further replies.
aljubicic

aljubicic

Programmer
Joined
Nov 7, 2002
Messages
82
Location
AU
Hi All,

Can anyone tell me the syntax for getting the system Date. In MS SQL it is 'GetDate()'. Is there a similiar function in Informix??

Thanks
Anthony
 
Sort by date Sort by votes
Hi,

The following SQL statement can be used to get the system date.

select today from systables where tabid=1 ;

Regards,
Shriyan
 
Upvote 0 Downvote
Hi:

In addition to Shriyan post, you can get the datetime with:

select current from systables where tabid = 1

Regards,

Ed
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

aft5425
  • Locked
  • Question Question
get records with distinct phone numbers only
Replies
2
Views
391
aft5425
aft5425
enriquegm82
  • Locked
  • Question Question
getting username from an informix 4gl program
Replies
3
Views
718
PHV
PHV
BlackDevilWS6
  • Locked
  • Question Question
Query Informix Datetime issue
Replies
2
Views
385
PHV
PHV
unique12u
  • Locked
  • Question Question
Most Recent Date
Replies
7
Views
518
unique12u
unique12u
magarwal1908
  • Locked
  • Question Question
Parser stack gets full. Querying informix db using odbc connection.
Replies
0
Views
371
magarwal1908
magarwal1908

Part and Inventory Search

Sponsor

Back
Top