Solved

How to get military time in Sybase?

Posted on 2016-07-15
3
86 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 26

Accepted Solution

by:
wilcoxon earned 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Troubleshooting common task sequence error codes
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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