- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
1. How to convert Military time to standard time
In SQL server 2008 there is one datatype present called "time". So when we create a column with this datatype, generally it store time in 24 hours format. At the time of selecting also we get that 24 hours time. Using following query helps in getting time in 12 hours format(AM/PM format).
EX: SELECT CONVERT(VARCHAR(20),CLASS_START_TIME,109) FROM TABLE_NAME
O/P- 7:00:00PM, 10:15:00AM etc. (hh:min:sec format)
EX: SELECT CONVERT(VARCHAR(20),CLASS_START_TIME,100) FROM TABLE_NAME O/P- 7:00PM, 10:15AM (hh:min format) |
2. How to show only last 2 digit of year while selecting any date
In SQL Server 2008 another one datatype is present called "date" which only stores the date. While selecting date we generally get date in MM/DD/YYYY format. Using following query we can get date in MM/DD/YY format only.
EX: SELECT CONVERT(VARCHAR, DATE_OF_BIRTH,1) FROM TABLE_NAME
3. How to get day of a particular date
Sometimes we need date and its corresponding day.Following query helps us in achieving that.
EX: SELECT DATENAME(WEEKDAY, CLASS_START_DATE) FROM TABLE_NAME |
Related Tags:
Database, SQL Server
Author: Monalisa Pradhan
Database
- Some Useful Date Time conversion Tips in SQL
- Which one to use in a SQL query:-"Not Exists"/ Left Join / Not In"?
- Consuming No space for storing NULL value in table
- How to use a comma seperated list as paramater to a stored procedure
- Set the Recovery model of the database to Simple/Full
- How to create temporary table in MySQL
- How to relocate database from C#.NET (SQL Server 2000)
- Importance of Max Degree of Parallelism in SQL Server
- How to display tabular data in CLR proc
- MySQL: Ordering values according to a predefined pattern
- Use of cross apply to show ',' separated values(SQL Server)
- MYSQL:Ordering A TextField Numerically
- How to select Random rows in SQL Server using TABLESAMPLE
- How to add dynamic data in to the SQL Report header and footer
- How To Set Page Break in a report Conditionally
- MySQL: Filter or Search Records Using Regular Expression
- MSSQL-Insert records for columns where IDENTITY is set
- Forming Comma Separated String in SQL Server
- How to create folders in SQLReport server dynamically ?
- Get database connection string using UDL files
- More Related Tips
