[SOLVED]using datetime to get info from database
Posted: Tue Sep 26, 2006 2:00 am
good day again
as you see below this is in combination with my last post (will delete that in a moment)
what i want to do is using lastcheck to get every single bit of information from a single day.
my current query also does that but wth that i get every thing from today using the TOP command.
what is a better way of doing this?
i tried a lot of different stamps but they won't work because i get something like:
error trying to convert datetime to char or something
this is the format i get this in: 26-9-2006 8:56:30
this is what i got right now:
as you see below this is in combination with my last post (will delete that in a moment)
what i want to do is using lastcheck to get every single bit of information from a single day.
my current query also does that but wth that i get every thing from today using the TOP command.
what is a better way of doing this?
i tried a lot of different stamps but they won't work because i get something like:
error trying to convert datetime to char or something
this is the format i get this in: 26-9-2006 8:56:30
this is what i got right now:
Code: Select all
SELECT top 288 Lastcheck, ServerName, TotalPhysicalMemorySize, TotalVirtualMemorySize, FreeVirtualMemory, FreePhysicalMemory
FROM @@@@_Server_Memory_used
WHERE (ServerName LIKE 'sr0029') AND (Lastcheck = 26-9-2006)
ORDER BY Lastcheck DESC