Posted By

highlyevolved on 11/04/09

Tagged

sql
date
convert

Versions (?)

Last Edited at 11/04/09 02:31pm

Statistics

Viewed 747 times

Favorited by 2 user(s)

Related snippets

Convert Date/Time in SQL

/ Published in: SQL

These statements convert a date/time field into just a date or a time field

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CONVERT(VARCHAR(10), "Enter Date/time field/parameter", "format type")
 
Example: CONVERT(VARCHAR(10), GETDATE(), 101)
 
 
Formats:
 
"101" selects DATE
"108" selects TIME

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.