Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

blackfish SQL database currenttime stamp

How can I get server time from Blackfish SQL Server by using SQL?
Is there a way similar to SQLServer?
0
dsr12
Asked:
dsr12
  • 2
1 Solution
 
wd123Commented:
according SQL 92 u can use DATE, TIME, TIMESTAMP.
0
 
jimyXCommented:
Blackfish does have Current_TimeStamp, did you try using it?
0
 
dsr12Author Commented:
HOw can it be in query like this: Select current_timestamp
0
 
jimyXCommented:
Yes, from any of your tables:
Select Current_TimeStamp from YourTable;
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now