How to Convert to a Date in Sybase

Sybase provides business solutions for those who want to benefit from digital customer relationship management (CRM) through the use of databases. This kind of database has optimization for business and customer management, which helps you keep live records of your clients and employees. To convert dates through Sybase, you might find it helpful if you already know how to access basic functions in the software's interface.

Instructions

1. Enter your Sybase software interface.

2. Select your database and access the query terminal.

3. Type the following query into the terminal: select convert(char(10), getdate(), 101). You may refer to the link in Resources for more information on what date formats you may use to convert dates. You must specify the first value with the number of characters in the date format. In this case, you get a date with 10 characters, and specify a 10-character output. You must change this as you change format.

Resources

• CompuSpec: Sybase Convert