?
Solved

How to get military time in Sybase?

Posted on 2016-07-15
3
Medium Priority
?
199 Views
Last Modified: 2016-07-18
In SQL server I can get the date in military time using the following Query:
SELECT CONVERT(TIME,GETDATE())
Example of output : 22:03:15.4700000

Is there any type of similar query in SYBASE which can give me the same result?
0
Comment
Question by:brgdotnet
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
wilcoxon earned 2000 total points
ID: 41713797
The below will do what you want.  The format in Sybase uses : instead of . for millisecond separator.  Also, some Sybase products do not appear to include the milliseconds at all.
select convert(varchar(99), getdate(), 14)

Open in new window

0
 
LVL 2

Author Comment

by:brgdotnet
ID: 41717955
Perfect, thank you!
0
 
LVL 2

Author Closing Comment

by:brgdotnet
ID: 41717956
Thank you so much.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am posting this in case anyone runs into similar issues that I did, this may save you a lot of grief: Condition: 1. Your NetBIOS domain name contains an ampersand " & " character.  (e.g. AT&T) 2. You've tried to run any Microsoft installation…
Don’ts and Dos are two important end products of software testing basics that a tester needs to regard. This article attempts to explain the principles of both.
Integration Management Part 2
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question