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 IamaSherpa 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
Nov 7, 2002
82
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
get records with distinct phone numbers only
Replies
2
Views
117
aft5425
aft5425
enriquegm82
  • Locked
  • Question
getting username from an informix 4gl program 1
Replies
3
Views
400
PHV
PHV
BlackDevilWS6
  • Locked
  • Question
Query Informix Datetime issue
Replies
2
Views
139
PHV
PHV
unique12u
  • Locked
  • Question
Most Recent Date
Replies
7
Views
174
unique12u
unique12u
magarwal1908
  • Locked
  • Question
Parser stack gets full. Querying informix db using odbc connection.
Replies
0
Views
137
magarwal1908
magarwal1908

Part and Inventory Search

Sponsor

Back
Top