> For the complete documentation index, see [llms.txt](https://dailyjournal.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dailyjournal.gitbook.io/notes/databases/relational-databases/microsoft-sql-server/extras.md).

# Extras

### DATE only formats

<table><thead><tr><th width="118.33333333333331">Format #</th><th width="437">Query</th><th>Format</th></tr></thead><tbody><tr><td>1</td><td>select convert(varchar, getdate(), 1)</td><td>mm/dd/yy</td></tr><tr><td>2</td><td>select convert(varchar, getdate(), 2)</td><td>yy.mm.dd</td></tr><tr><td>3</td><td>select convert(varchar, getdate(), 3)</td><td>dd/mm/yy</td></tr><tr><td>4</td><td>select convert(varchar, getdate(), 4)</td><td>dd.mm.yy</td></tr><tr><td>5</td><td>select convert(varchar, getdate(), 5)</td><td>dd-mm-yy</td></tr><tr><td>6</td><td>select convert(varchar, getdate(), 6)</td><td>dd-Mon-yy</td></tr><tr><td>7</td><td>select convert(varchar, getdate(), 7)</td><td>Mon dd, yy</td></tr><tr><td>10</td><td>select convert(varchar, getdate(), 10)</td><td>mm-dd-yy</td></tr><tr><td>11</td><td>select convert(varchar, getdate(), 11)</td><td>yy/mm/dd</td></tr><tr><td>12</td><td>select convert(varchar, getdate(), 12)</td><td>yymmdd</td></tr><tr><td>23</td><td>select convert(varchar, getdate(), 23)</td><td>yyyy-mm-dd</td></tr><tr><td>101</td><td>select convert(varchar, getdate(), 101)</td><td>mm/dd/yyyy</td></tr><tr><td>102</td><td>select convert(varchar, getdate(), 102)</td><td>yyyy.mm.dd</td></tr><tr><td>103</td><td>select convert(varchar, getdate(), 103)</td><td>dd/mm/yyyy</td></tr><tr><td>104</td><td>select convert(varchar, getdate(), 104)</td><td>dd.mm.yyyy</td></tr><tr><td>105</td><td>select convert(varchar, getdate(), 105)</td><td>dd-mm-yyyy</td></tr><tr><td>106</td><td>select convert(varchar, getdate(), 106)</td><td>dd Mon yyyy</td></tr><tr><td>107</td><td>select convert(varchar, getdate(), 107)</td><td>Mon dd, yyyy</td></tr><tr><td>110</td><td>select convert(varchar, getdate(), 110)</td><td>mm-dd-yyyy</td></tr><tr><td>111</td><td>select convert(varchar, getdate(), 111)</td><td>yyyy/mm/dd</td></tr><tr><td>112</td><td>select convert(varchar, getdate(), 112)</td><td>yyyymmdd</td></tr></tbody></table>

### TIME only formats

<table><thead><tr><th width="121.33333333333331">Format #</th><th width="438">Query</th><th>Format</th></tr></thead><tbody><tr><td>8</td><td>select convert(varchar, getdate(), 8)</td><td>hh:mm:ss</td></tr><tr><td>14</td><td>select convert(varchar, getdate(), 14)</td><td>hh:mm:ss:nnn</td></tr></tbody></table>