Database Discussion Boards

George_George12-Jan-09 21:14

12-Jan-09 21:14

Hello everyone,

Any ideas what is the differences between GETUTCDATE and GETDATE? And when to apply GETUTCDATE and when to apply GETDATE?

thanks in advance,
George

Re: GETUTCDATE and GETDATE

Reza Raad12-Jan-09 21:44

Reza Raad

12-Jan-09 21:44

getutcdate means : Coordinated Universal Time
and return universal time regardless your time zone
but getdate return time based on your time zone:

<br />
SELECT 'SYSDATETIME()      ', SYSDATETIME();<br />
SELECT 'SYSDATETIMEOFFSET()', SYSDATETIMEOFFSET();<br />
SELECT 'SYSUTCDATETIME()   ', SYSUTCDATETIME();<br />
SELECT 'CURRENT_TIMESTAMP  ', CURRENT_TIMESTAMP;<br />
SELECT 'GETDATE()          ', GETDATE();<br />
SELECT 'GETUTCDATE()       ', GETUTCDATE();<br />
/* Returned:<br />
SYSDATETIME()            2007-05-03 18:34:11.9351421<br />
SYSDATETIMEOFFSET()      2007-05-03 18:34:11.9351421 -07:00<br />
SYSUTCDATETIME()         2007-05-04 01:34:11.9351421<br />
CURRENT_TIMESTAMP        2007-05-03 18:34:11.933<br />
GETDATE()                2007-05-03 18:34:11.933<br />
GETUTCDATE()             2007-05-04 01:34:11.933<br />
*/<br />

Human knowledge belongs to the world

Re: GETUTCDATE and GETDATE

George_George13-Jan-09 0:31

George_George

13-Jan-09 0:31

Thanks Reza,

Could I understand GETDATE returns machine local time?

regards,
George

Re: GETUTCDATE and GETDATE

Reza Raad13-Jan-09 2:53

Reza Raad

13-Jan-09 2:53

George_George wrote:
Could I understand GETDATE returns machine local time?

GetDate() returns current date of your sqlserver machine(means the server where your sqlserver installed)

Human knowledge belongs to the world

Re: GETUTCDATE and GETDATE

George_George14-Jan-09 2:10

George_George

14-Jan-09 2:10

Thanks Reza!

regards,
George

Re: GETUTCDATE and GETDATE

Wendelius12-Jan-09 21:45

Wendelius

12-Jan-09 21:45

GETUTCDATE returns current date of the system in UTC time (Greenwich Mean Time) while GETDATE return current time in the timezone where the system is working.

The need to optimize rises from a bad design.My articles[^]

Re: GETUTCDATE and GETDATE

George_George13-Jan-09 0:31

George_George

13-Jan-09 0:31

Thanks Mika!

regards,
George

Re: GETUTCDATE and GETDATE

Wendelius13-Jan-09 0:45

Wendelius

13-Jan-09 0:45

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Re: GETUTCDATE and GETDATE

J4amieC13-Jan-09 1:47

J4amieC

13-Jan-09 1:47

For pete's sake george your questions are becoming more asanine by the day.

What the bloody hell do you think the difference would be given the method names are very explicit.

Re: GETUTCDATE and GETDATE

George_George13-Jan-09 2:13

George_George

13-Jan-09 2:13

Thanks J4amieC,

I appreciate people'e help here. I am a newbie. Smile | :)

regards,
George

Re: GETUTCDATE and GETDATE

J4amieC13-Jan-09 3:03

J4amieC

13-Jan-09 3:03

George_George wrote:
I am a newbie.

You dont say?!

However, newbie aside, one of the most important skills you must learn if you want to work in this profession is how to look thinks up.... wait, im wasting my time again! You've had this point explained ad infinitum.

Re: GETUTCDATE and GETDATE

George_George14-Jan-09 2:11

George_George

14-Jan-09 2:11

Sorry for any in-convenience, J4amieC! Smile | :)

I am catching-up with SQL Server soon.

regards,
George

Re: GETUTCDATE and GETDATE

Hamid_RT15-Jan-09 2:30

Hamid_RT

15-Jan-09 2:30

See What Is the Difference Between GETDATE() and GETUTCDATE()?[^] and Date and Time Functions[^].

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: GETUTCDATE and GETDATE

George_George15-Jan-09 18:19

George_George

15-Jan-09 18:19

Good stuff, thanks Hamid!

regards,
George

Which database is best for my application.

Nanda_MR12-Jan-09 18:46

Nanda_MR

12-Jan-09 18:46

I m creating a application it record information per min 4*32 set of record.
So which database i can use. I am planning to MYSQL. is it any other best database is there

Note: I need a mass storage.

Thanks in advance.

Re: Which database is best for my application.

Reza Raad12-Jan-09 18:51

Reza Raad

12-Jan-09 18:51

The Oracle can be good selection
but why this mass of record??!!

Human knowledge belongs to the world

Re: Which database is best for my application.

Nanda_MR12-Jan-09 20:15

Nanda_MR

12-Jan-09 20:15

My program like that it store one second 4*32. A machine send that much set of record.

Re: Which database is best for my application.

Wendelius12-Jan-09 22:22

Wendelius

12-Jan-09 22:22

Do you mean that yo will store 128 records per minute. If so, that isn't so much, but if the amount rises, I think the first bottleneck will be the program storing those records and the possible network between the program and the database. Most of the databases canhandle that amount easily as long as the commands can be delivered to them fast enough.

One consideration is also that do you insert every record separately or can you make insertions as a batch. For example SQL Server client in .Net framework has SqlBulkCopy class which might be useful. Also SqlDataAdapter can handle batches. I'm not sure what's the sitatuation with MySQL client.

The need to optimize rises from a bad design.My articles[^]

Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet [modified]

shaik abdul gani12-Jan-09 17:26

shaik abdul gani

12-Jan-09 17:26

Dear Team,

I have an requirement in windows applications, that i have to execute 3 oracle procedures parllely in an single click event.
is there is any way of doing this. Like

1) using the multi threading concept.
2) can we pass three procedures at a time in commandtext

or any alternative way of doing this or any link related to it.

Thanx in advance .

modified on Tuesday, January 13, 2009 1:48 AM

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet

Wendelius12-Jan-09 21:47

Wendelius

12-Jan-09 21:47

You could use threading using BackgroundWorker class. I think that would be the easisest way. You can't pass several commands simultaneously with an OracleCommand.

The need to optimize rises from a bad design.My articles[^]

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet

shaik abdul gani13-Jan-09 6:11

shaik abdul gani

13-Jan-09 6:11

thanks a lot mika ..

i will try for it ...

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet

Wendelius13-Jan-09 6:15

Wendelius

13-Jan-09 6:15

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet [modified]

shaik abdul gani15-Jan-09 20:46

shaik abdul gani

15-Jan-09 20:46

HI Mika

i tried to run the procedure using the backgroundworking class. but for time being instead of oracle procedure for testing i have just used simple select statments.

i am just pasting here the code

System.ComponentModel.BackgroundWorker worker = new System.ComponentModel.BackgroundWorker();
private static string ConnectString = "connectionstring";// this is not the actual connection
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
DataSet ds3 = new DataSet();
private void button1_Click(object sender, EventArgs e)
{
worker.DoWork += new System.ComponentModel.DoWorkEventHandler(SomeLongRunningTask);

worker.RunWorkerAsync();
OracleConnection con = new OracleConnection(ConnectString);

OracleCommand command = new OracleCommand(" select * from CIHOLDDETAILS", con);
OracleDataAdapter da = new OracleDataAdapter(command);
da.Fill(ds);

}
// private delegate void DoWorkDelegate();

private void SomeLongRunningTask(object sender, System.ComponentModel.DoWorkEventArgs e)
{
//using (OracleConnection cn = new OracleConnection(ConnectString))
//{

OracleConnection cn = new OracleConnection(ConnectString);
OracleCommand cmd = new OracleCommand(" select * from CIINSPECTIONREPORTS", cn);
OracleDataAdapter orda = new OracleDataAdapter(cmd);
orda.Fill(ds2);

// DoWorkDelegate worker2 = new DoWorkDelegate(loaddata);

//}

}

private void worker_RunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventHandler e)
{

loaddata();
}

private void loaddata()
{
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();

dt = ds.Tables[0].Copy();
dt2 = ds2.Tables[0].Copy();
ds3.Tables.Add(dt);
ds3.Tables.Add(dt2);
dataGridView1.DataSource = ds3;
}

here RunWorkerCompleted is not firing i have done this code using this link

http://www.knowdotnet.com/articles/backgroundworker.html

please help me whats the problem here.

thanx in advance

modified on Friday, January 16, 2009 4:29 AM

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet

Wendelius16-Jan-09 9:16

Wendelius

16-Jan-09 9:16

As far as I can see you haven't wired the event. Try adding the following to the button click before you call RunWorkerAsync:

worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);

The need to optimize rises from a bad design.My articles[^]

Re: Executing Multiple Oracle Procedures Parallel( not in sequence) in dotnet

shaik abdul gani18-Jan-09 21:59

shaik abdul gani

18-Jan-09 21:59

thanx a lot mika

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.