<div>
HI<br />
<br />
See how to convert the data to AM/PM in your select statement at<br />
<a href="http://www.sql-server-helper.com/tips/date-formats.aspx" rel="ugc">http://www.sql-server-helper.com/tips/date-formats.aspx</a>
</div>


<div>
Hi,<br />
<br />
If &quot;2009-02-28 00:00:00.000&quot; is what you get when querying your datetime field, then you don't have any time information stored, and you can't check for AM/PM. How do you insert/update the datetime info?<br />
<br />
/peter<br />
<br />

</div>


<div>
&gt;&gt;you don't have any time information stored&lt;&lt;<br />
Sure you do. &nbsp;By its very nature datetime always contains a date and time portion.<br />
<br />
&gt;&gt;you can't check for AM/PM.&lt;&lt;<br />
Sure you can. &nbsp;See my previous comments.
</div>


<div>
My interpretation of the question was that the timeportion of the datetime field in every record was set to 00:00:00'. That pattern tells me that the timeportion isn't set by the user, since SQL defaults to '00:00:00' when you only set the dateportion, like date = '2009-02-28' is stored in db as '2009-02-28 00:00:00'. &nbsp;<br />
And in that case (of course I might have misunderstood) there is no valid (from the users perspective) time stored and hence the AM/PM check is not valid. 
</div>


<div>
Pivar Exactly, This how the Date Time info is entered. I need to add a way to enter it so that I can determine AM versus PM and then pull only those records that are AM or vice versa. Thank you<br />
<br />
<br />
Private Sub txtDate_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDate.GotFocus<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'Puts Today's Date in Text Box<br />
&nbsp; &nbsp; &nbsp; &nbsp; txtDate.Text = Date.Now<br />
&nbsp; &nbsp; End Sub<br />

</div>


<div>
Thanks for all the help. I decided to create a column for the input AM or PM. Then in VB I have it auto fill the appropriate marker based on Date.Now using the following code.<br />
<br />
Private Sub txtAM_PM_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtAM_PM.GotFocus<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If DatePart(DateInterval.Hour<wbr />, Date.Now) &lt;&nbsp;12 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtAM_PM.Text = &quot;AM&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; ElseIf DatePart(DateInterval.Hour<wbr />, Date.Now) &gt;&nbsp;11 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtAM_PM.Text = &quot;PM&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; End Sub<br />

</div>


<div>
&gt;&gt;SQL defaults to '00:00:00' when you only set the dateportion, like date = '2009-02-28' is stored in db as '2009-02-28 00:00:00'.&lt;&lt;<br />
Actually SQL Server does not store datetime values in that format or any regional format for that matter. &nbsp;DateTime values are stored as 2 integers. &nbsp;One integer for the date and the other for the time.<br />

</div>


<div>
<div class="content wysiwyg-content">
I need to sort my records into those created in the AM and those created in the PM I have a field that holds the date, how some ever, It only has the date in it when I look at the records in MS SQL. I am building a VB 2008 front end for a MS SQL 2005 express back end. So, I need to store the full date time for each record and then be able to pull a report on just the AM records or just the PM records. This is what is stored in the date column in SQL: 2009-02-28 00:00:00.000<br />

<pre><code class="code-1 nolinks" id="code-263250"><span>Private Sub txtDate_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDate.GotFocus</span>
<span>        'Puts Today's Date in Text Box</span>
<span>        txtDate.Text = Format(Now, &quot;General Date&quot;)</span>
<span>    End Sub</span>
</code></pre>
</div>
</div>


I need to sort my records into those created in the AM and those created in the PM I have a field that holds the date, how some ever, It only has the date in it when I look at the records in MS SQL. I am building a VB 2008 front end for a MS SQL 2005 express back end. So, I need to store the full date time for each record and then be able to pull a report on just the AM records or just the PM records. This is what is stored in the date column in SQL: 2009-02-28 00:00:00.000

Date Time AM versus PM

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.