I want store date and time separate in database

Question

0.00/5 (No votes)

See more:

i have 4 columns in database, when i login it shold store username and date and time. but i am getting date with time. i dont want like that i want to store separate date and time

Posted 21-Sep-11 22:40pm

jayanthik

Add a Solution

Comments

DaveAuld 22-Sep-11 4:44am

Why do you want to store it as 2 seperate fields?

jayanthik 22-Sep-11 5:02am

i want to track login and logout time at the end of the day i want to calculate hw many hrs he spended so ineed to store time separately

Tejas Vaishnav 22-Sep-11 4:48am

Please See your table structure so i can give you a query for storing date and time separately...

jayanthik 22-Sep-11 5:02am

i want to track login and logout time at the end of the day i want to calculate hw many hrs he spended so ineed to store time separately

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-09-21T22:54:00

Solution 2

It's not normally a good idea to store them separately - a DateTime variable is not a date and a time as in "24/11/2008 13:45:16" it is a "this number of milliseconds since an agreed starting point" so specifically storing a time alone is a bit difficult, and would be somewhat wasteful.
Perhaps what you want to do is store a difference in times (a Timespan) instead? That could be the number of milliseconds since midnight, which could then be applied to any base DateTime.

Posted 21-Sep-11 22:54pm

OriginalGriff

Comments

jayanthik 22-Sep-11 5:02am

i want to track login and logout time at the end of the day i want to calculate hw many hrs he spended so ineed to store time separately

OriginalGriff 22-Sep-11 5:07am

So it is a bad idea to store the time separately - what if he logs in at 23:50, and out at 00:10 the following day? The elapsed time is 20 minutes, but if you store only the time, you don't know that.

Mehdi Gholam · Answer 2 · 2011-09-21T22:52:00

Solution 1

C#

string timeonly = DateTime.Now.ToShortTimeString();
string dateonly = DateTime.Now.ToShortDateString();

Posted 21-Sep-11 22:52pm

Mehdi Gholam

Tejas Vaishnav · Answer 3 · 2011-09-21T23:18:00

SQL

CREATE TABLE UserLogin (
	ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
	UserName NVARCHAR(20),
	LoginDate Date,
	LoginTime Time
)

IF YOU INSERT DATA WITH THE USE OF STOREPROCEDURE THEN USE THIS AS YOUR PROCEDURE

SQL

DECLARE @userName NVARCHAR(20);
--SET @userName = 'Tejas Vaishnav';
INSERT INTO UserLogin (UserName,LoginDATE,LoginTIME) VALUES (
@userName,
cast(convert(varchar,getdate(),101) as date),
cast(convert(varchar,getdate(),108) as time)
)

or you want it from your code behind page or c#
then use this

C#

DateTime.Now.ToShortDateString();
DateTime.Now.ToShortTimeString();

For More Detail on DateTime and Convert or Cast see this link
DateTime[^]

I want store date and time separate in database

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us