PC Unleashed

Unleash all your PC can do!

  • Browsers
    • Browsers Tips
    • Chrome
    • Firefox
    • Flock
    • Internet Explorer
    • Safari
  • Databases
    • MySQL
  • Design
    • Branding
    • Design Process
    • Flash
    • Galleries
    • Icons
  • Development
    • CSS
    • HTML
    • Java
    • Javascript
    • JQuery
  • Miscellaneous
    • Cloud Computing
    • Computers
    • Email
    • Gaming
    • Google Services
    • Hardware
    • Mobile
    • Servers
    • Networking
    • Tips and Tricks
    • Virtualization
    • Social Media
    • Usability
    • Tech News
    • Tutorials
    • Search Engines
    • Software
    • Web Design
    • Visio
    • Visual C#
    • WordPress
  • MS Office
    • Access
    • Excel
    • InfoPath
    • SharePoint
    • Word
  • Safety
    • Identity Theft
    • Viruses and Malware
  • Operating Systems
    • Android
    • Blackberry OS
    • Linux
    • Mac
    • iOS
    • Windows XP
    • Windows Vista
    • Windows 7
    • Windows 8
    • Windows 8.1
    • Windows 10
    • Windows general questions
      • SQL Server
    • Windows 2003
    • Windows 2008

Get 12-Hour Time from Datetime Datatype in SQL Server 2005

March 3, 2016 by PCU-publisher

It's not as simple as you may think to extract the time in a 12-hour format (as opposed to 24-hour, military format) from a datetime field in SQL Server 2005.   Let me walk you through the solution. First, let's select the datetime field. SELECT getdate() AS MyTime If you didn't want to use the current time, then you can of course substitute the appropriate field in like so: SELECT mydatetimefield AS MyTime FROM mytable For simplistic sake, I'll just use getdate() going forward in this tutorial as my source datetime field.  The result should result in the current date and time: 2010-11-07 12:04:17.903 Next, we're going to convert … [Read more...]

Filed Under: SQL Server, Tutorials, Windows general questions Tagged With: databases, datetime, getdate, sql server 2005

How to Use Aggregate Functions in Your Queries

October 27, 2015 by PCU-publisher

If you’re new to writing SQL queries, you may not know about aggregate functions. These handy tools can provide you with some quick information about your tables. For example, you can use aggregate functions to find the number of rows in your table or to do simple calculations like find the minimum or maximum values in a column. Let’s take a closer at how aggregate functions work:   How Aggregate Functions are Different from Basic Queries – If you’re learning to write queries, you’re probably comfortable with the “SELECT * FROM Tablename” syntax to return all the rows in a table. When you use a function in your query, you’re only … [Read more...]

Filed Under: SQL Server, Tutorials Tagged With: aggregate functions, query functions, query syntax, SQL

Tags

Android apple apps browser browsers Chrome computer computers dropbox email Excel excel 2010 facebook Firefox Gmail google IE internet Internet Explorer ios iphone Mac microsoft Microsoft Office Microsoft Word mobile office office 2010 online Opera operating system PC security software spreadsheet storage technology Tips Tricks wifi Windows Windows 7 windows 8 Word word 2010
Copyright © 2018 PCUnleashed.com