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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert time to 24 hour clock

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Anyone know if Sybase has a function to do this? For example 2:00 PM = 1400

Thanks in advance
 
Sort by date Sort by votes
Hiya,

The way that Sybase shows times is dependant on the language that it is set to. If you look in the Sybase manual, it should show you all the different ways that it can express it.

Tim
 
Upvote 0 Downvote
Probably 'select convert(char,<date_field>,8)' should be it.
 
Upvote 0 Downvote
Hi,

Use this

select convert(char(2),getdate(),8)+right(convert(char(5),getdate(),8),2)


It works for sure

RD
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question Question
Need help with SQL query to update a Micros report
Replies
0
Views
865
AM_WG
AM_WG
raphael75
  • Locked
  • Question Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
515
raphael75
raphael75
baltman
  • Locked
  • Question Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
567
baltman
baltman
joeb007
  • Locked
  • Question Question
Function: Time stamps for today
Replies
0
Views
475
joeb007
joeb007
djjd47130
  • Locked
  • Question Question
Converting Sybase DB to MSSQL
Replies
1
Views
384
djjd47130
djjd47130

Part and Inventory Search

Sponsor

Back
Top